Consulting | Excel Examples

Input Validation

Keywords: Input Validation, Range, OnEntry, Data Entry

Description: Excel's OnEntry property provides a way to validate data entered in a worksheet cell.

Tip: You can set a worksheet's OnEntry property in an Auto_Open macro. When data is entered in a cell on the worksheet, the macro specified in the OnEntry property will run. If the data is not valid, the OnEntry procedure will display a message box and set an error message next to the invalid data.

Guide to the Example: Enter a value in cell B2 of the worksheet. If the value is less than 0 or greater than 100, an error message will be displayed in a message box and the value will be marked as an Error in column C.

Download File: Click Here
Tip: Click on the link above and choose "Save" to download the xls workbook to your hard drive or "Open" to open the workbook inside of your browser.


Last modified: May 21, 1996