Text box validation - date entry - format "dd mm yyyy"

Hi I am trying to tie down users to only entering a date in the correct format in a number of text boxes on a userform.
I'm nearly there but am trying to code for the event where a date will have the correct number of characters but with no spaces or if "-" and "/" are used.

The attached example seems to go so far but if the date "10 03 2016" is entered as "10032016" then an error is thrown highlighting line

Please Login or Register  to view this content.

Any pointers appreciated

Thanks Jindon, thats perfect. I'll look now at how to restrict use of "/" and "-"

This cured the "10031962" by correctly formatting as "10 03 1962"

But, if numeric incorrect date entered "1003" this gets formatted as "00 00 1003" rather than a message box warning which is required.

Can the entry be restricted to two blocks of 2 digits and a block of 4 digits all separated by spaces ?


Made slight change and getting to the stage where liveable...Many thanks

Please Login or Register  to view this content.

Hi Jindon
2 userforms, one is multipage, all text box references unique to the page
both userforms in same workbook

Have the amended comboCalendar launching on text box select - have added a command button, just need that to write back to the userform