Use a second userform in place of an input box help

Assume the user input was mmddyyyy,

Did you mean to say "was not" mmddyyyy?
If you are looking to validate the date the user entered, usually that is done after they input the date via the code. If it's not valid you can display a message box where they can click ok which can put them back into the same form to try again or they can click cancel to go on to something else.

Hi
Is it like this?

Just so you know IsNumeric doesn't just accept numbers like 123. It will happily accept numbers such as 123.45 and $4.00 so if you want to restrict to 6 integers with no dollar signs or decimals this is not a good choice.

I've attached a small example of how to validate the user input.
There are several things you can do.
1) You can make sure the user entered 6 digits only, not less than 6 and not more than 6. No spaces or non numbers.

2) You can also restrict which numbers are used in each position. In the example I gave you two boxes. One allows 0-9 in each of the 6 positions. The second box does not allow leading zeros. For example 012345 would be invalid. You can restrict all 6 positions if you like, in other words no zeros in the first position, 0-4, in the second 1-5, in the third etc.

Good Luck!!!