Leading the way in Microsoft Office Development

What is Data Validation ?

The main purpose of data validation is to create restrictions on the type of data that can be entered in a cell.

Very useful for preventing the entry of incorrect data or data that does not meet a particular criteria.

Data Validation only restricts the data that is entered - the cells can still be deleted or pasted over.

Data Validation is a way to validate your data without doing any actual programming.

What can you use Data Validation for ?

1) For restricting the type of data that can be entered in a particular cell.

2) To provide a drop-down list of values that can be entered in a particular cell.

3) Displaying a descriptive prompt to remind users what type of information should be entered in a cell.

4) Displaying an error message if the user enters an invalid value in a cell.

5) Prevent a value appearing more than once.

6) numbers within a specific range.

7) a certain number of characters to be entered.

Using Data Validation

This can be found by selecting (Data > Validation).

Using Named Ranges

Things to Remember

If you copy a cell and paste it over a cell that has Data Validation applied to it then the validation will be lost without a prompt.

You can copy data validation from one cell to another by using the (Edit > Copy) and (Edit > Paste Special) dialog box.

If you want to apply data validation to a large block of cells, it is easier to add the data validation to just one cell and then copy and paste the data validation using the Paste Special dialog box.

These rules only apply to data that is entered into a cell manually and does not work on data that is pasted into cells using a macro ??