More detail to help refine an answer.
I would like an "Error Alert" to occur at the time the
user enters or tabs away from the text box to the next
text box - thereby not having them enter data in all text
boxes on the user form and then the transfer of data to
the worksheet fails.
I currently have an "if" <6 statement at time of
selecting "OK" but unsure of how to relate this to the
actual textbox to save frustration of user having to then
reenter all data.
What do you use to display "error alerts"

Thanks again,
Kev.
-----Original Message-----
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.
.