MAcro for validation of Date

[junx13]

Hi,
thanks for the reply, but as my worksheets are dynamic, I need t
do this programmatically and thus my request for any inkling on how t
do a macro to do this... thanks anyway

 

[Guest]

Hi
for a macro solution you would need a worksheet_change event handler which
checks the value of the entered data.
e.g. using
IsDate(target)

See:
http://cpearson.com/excel/events.htm