Microsoft Office Tutorials and References
In Depth Information
Adding an Input Message
You’ll see a drop-Down menu entitled Style that stores three options. The first
is Stop , the Data Validation default whose error message is the one we’ve
already seen. The second is called Warning . Select it and another Title/Error
Message set of fields appears, enabling you to type whatever customized
prompts you wish. But when selected, Warning allows the user to go ahead and
enter data even if it violates the data validation rule. If I choose the Warning
option for range H3:H40, and then type CAL in H3, this default message
appears (Figure 6–58):
Figure 6–59. Don’t say we didn’t warn you: Overriding the restriction, if you wish
If I click Yes, CAL will be accepted anyway.
The third prompt, Information , works just slightly differently. It too allows you
to proceed with data entry that violates the data validation rule, but its default
message simply notifies the user of the violation, without asking if he/she wants
to continue. Here clicking OK automatically accepts the data (Figure 6–59):
Figure 6–60. An information message prompt: Not as informative as the previous warning
Again, all three Error Alert possibilities allow you to customize your own prompts, affording you the
opportunity to indulge in some gentle and prudent office humor, such as this (Figure 6–60):
Search JabSto ::

Custom Search