Monday, January 14, 2008
Disallow Special Characters Using Data Validation
Excel’s data validation is a wonderful tool for ensuring that only acceptable data is entered into a cell. This is particularly helpful when users other than the one who created the worksheet will be filling in the data. The data validation tool allows you to set up rules that govern the types of data that are allowable, to present input messages that inform the user about the rules, and to display error messages if the rules are violated. Quite obviously, this can reduce errors in the worksheet.
The most powerful type of data validation is the Custom type, which is based on formulas. In
Posted by Tim on 01/14 at 11:54 PM in
Data Validation
in
Functions
in
String Functions
in
Search
in
VBA
Comments (0) • Permalink • Tell-a-Friend
Comments (0) • Permalink • Tell-a-Friend
Page 1 of 1 pages
