VBA Won't run inside of a cell. Take a look at this:
http://www.contextures.com/xlDataVal06.html#Date

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Brad" wrote:

Thanks for taking the time to read my question.

I want to write a function that is executed before the user exits a specific
cell. The purpose is to check the format of the date that has been entered,
and make the user correct it if it's wrong.
The reason is I'm getting stuff like:
Mar. 12-2010
12/Mar-10
10-12-Mar
12.2010.03

Some are date formats and some aren't even close...

Dates will be in a specific column or specific cell, so I need to execute
the function before the user leaves that cell or column. Not sure how to do
that. I know in MS Access there is a BeforeUpdate, but don't see anything
like that in Excel.

Thanks for your help

Brad