Microsoft Office Tutorials and References
In Depth Information
Adding Data Entry Instructions with Input Messages
Let's see how to customize a data validation prompt:
1.
Select the range of cells to which you’ve assigned the Data Validation
rule.
2.
Click Data Validation and click the Error Alert tab.
3.
Select the Error Alert type you want to apply from the Style drop-down
menu.
4.
Type a Title and customized message. For example—if you select the
Warning type, you could entitle the message Character Limit, and write:
Only two characters permitted in this cell.
5.
Click OK.
Once that’s done, enter CAL—that is,
three characters, and press Enter; you’ll
see
Figure 2–47. Don’t say we didn’t warn you: A Warning
Error Alert. The user will still be allowed to enter three
characters anyway.
Note the Continue? prompt, which is supplied by Excel.
Adding Data Entry Instructions with Input Messages
We’ve seen that Error Alerts tell the user if they’ve violated a data validation, and what
they’ve done wrong. Input messages tell the user what sort of data is permitted in cells
before the data is entered.
To demonstrate how this works:
1.
Select that same range of cells with which you’ve been working.
 
Search JabSto ::




Custom Search