VBA DATE FORMAT : dd/mm/yyyy

[whitewhisper]

I have a userForm that asks the date of birth of a client.
The date has to be entered in the textBox only like this format: dd/mm/yyyy or else I don't want it to accepted (For example: this format should NOT work: mm/dd/yyyy )

I need help with the code... thanks!

 

[Jonmo1]

This will be problematic for ambiguous dates (Day is 12 or less).
Say If the user entered 7/11/2014

It would be impossible for VBA to know if the user's 'Intent' was for that to be November 7th, or July 11th.

You can dictate to VBA that it should treat it as November 11th.
But that does nothing to prevent the user from actually entering it that way believing it to be July 11th.

The best you could do is to put an instruction in the message box that it needs to be entered as dd/mm/yyyy

The only way I can think of that would be absolute.
Is to force the user to enter the month Name like Nov 7, 2014 or similar.