How to Check Date Format using Macro Enetred by User ....

[mangaldeep]

Hi All

My question is that how can i check the date format in vba code .
In my excel file end user can enter any type of date format . But i want to restrict them to enter the date only in (dd/mm/yyyy).

means if user enter "01/13/2013" then it should return error .
Please help me i am searching a lot for that but i dont get right answer

[AndyLitch]

This will trap the specific error

Please Login or Register  to view this content.

but bear in mind that it can only detect a date error for dates entered after the 12th of each month...

[mangaldeep]

Thanks AndyLitch


I m trying your code ....