First, take a look at the "Prevent entry of invalid data in a cell"
topic in XL Help.

For more, see

http://www.contextures.com/xlDataVal01.html




In article ,
Danie wrote:

How do I validiate the data entered in a cell just after the user has entered
it.