I have a user form with a text box that I want only to
accept numbers with 6 digits.
How do you format text box to accept only numbers - which
can have preceding zeros? Can this format be carried
through to the worksheet where these numbers will be
stored?
How do you alert the user, prior to them moving onto the
other text boxes on the user form, that they have not
entered valid data and should reenter the data?

Thanks a million,
Kev.