Microsoft Office Tutorials and References
In Depth Information
Validating Excel Worksheet Content
Error Alert. This type of message is a bit
stronger than an Input Message, and
instead of appearing before any entry is
made in a selected cell, it only pops up if
someone makes an entry that’s in violation
of the established validation rules for the
cell in question. As shown in Figure 14-27,
you can choose the style of alert (Stop,
Warning, or Information) and then type
the title and body of the error message.
If you only want particular numbers in
the selected range, an informative Warning
such as this will help users mend their ways.
Turning Off Data Validation
You can turn off Data Validation at any
time, by selecting the cells where you no
longer want any rules to apply and then
clicking the Clear All button in the Data
Validation dialog box. This puts the Allow
setting back to Any Value, which will end
validation rules and also make any Error
Alerts moot—nothing will trigger them. If
you’ve set up an Input Message, however,
you will have to use that tab in the Data
Validation dialog box to turn off the message.
Simply remove the check next to Show Input
Message When Cell Is Selected.
Users can be told to Stop, given a Warning,
or simply provided with passive Information
if you set up an Error Alert.
When you’ve created your Input Message and/or
Error Alert (yes, you can do both), you can test
them to see what the users will see when they
use your workbook and attempt to make an
entry in an area subject to validation rules.
Figure 14-28 shows the error message that
appears when an attempt to enter anything
other than a value between .5 and 20.5 was
made. Note that the gentle reminder set up in
the Input Message tab also appears.