Hi,

Excel 97, Excel 2003
cell format dd/mm/yy

Q.
In the Worksheet Change routine I have the following code

If IsDate(Target) = False Then
MsgBox
End If

Entries such as 32/10/04, 1/100/04 are quite happily accepted as dates.
Advice gratefully appreciated.

If possible I would rather trap with code rather than using data validation.

Thanks for any assistance

Don