Data Validation: Error Alert

The Error Alert prompts people to fill in the right data. The Error Alert has a Title, Error message and a Style.

 

5. Try it: Edit the Error Alert

Go to the Error Alert Tab.

Select the Style: Information

Title: Click CANCEL and try again

Error Message: Select a client from the list.

 

Click OK and keep going...

 

 

Memo to Self: There are three Styles of Error Alerts: Stop, Warning, or Information. Each one has a different symbol and a different sound. Something as simple as picking a name from a list is Information, not a Critical Stop with every bell and whistle firing....really.


The Computer Mama has a theory that the more you help your users, instead of scaring the wits out of them, the more they will be inclined to use your forms.

Data ->Data Tools-> Data Validation

Exam 77-888: Microsoft Excel Expert 2010

2. Applying Formulas and Functions

2.4. Apply functions in formulas: Data Validation Error Alert