Microsoft Office Tutorials and References
In Depth Information
Defining valid sets of values for
9
In the Input Message box, enter Please enter the customer’s credit limit,
omitting the dollar sign and any commas.
10
Click the Error Alert tab to display the Error Alert page.
11
In the Style list, click Stop to change the icon that appears on your message box.
12
In the Title box, enter Error , and then click OK .
13
Click cell J7 . When you do, a ScreenTip with the title Enter Limit and the text Please
enter the customer’s credit limit, omitting the dollar sign and any commas appears
near cell J7 .
14
Enter 25001 , and press Enter . A stop box with the title Error opens. Leaving the Error
message box blank in step 12 causes Excel to use its default message.
15
Click Cancel to close the error box.
IMPORTANT By clicking Retry, you can edit the bad value, whereas clicking Cancel
deletes the entry.
 
Search JabSto ::




Custom Search