Limit number entry in Userform TextBox to exactly 6 digits

Hi

I have a Userform where users need to enter a 6 digit reference number in Textbox1, is anyone aware how I can add code to the Textbox to only only 6 digits? and produce a message box if someone enters less or more than 6 digits?

Many thanks

Greg

Hi MickG

Thanks for your reply.

Parts 1 and 2 work perfectly, part 3 is almost there.

If I enter less than 6 digits and click on the next textbox field positioned in the same frame as textbox1, I receive the message to enter 6 numbers, if I click on the Datepicker field, also in the same frame, I receive the error message however it then allows me to select a date and doesn't bring up the error message again. If I click on other textbox fields or comboboxes on the form which are positioned on a multipage I don't get the error message and I'm allowed to submit the form which then produces an email.

If I then close or send the email, the userform closes which is correct, and sitting behind that I then have the message to advise to enter 6 numbers, so the message is populating however it's allowing me to complete fields positioned in the multipage element of the form and also submit the form

Any thoughts?

Thanks for your help

Greg

I should just replace that last bit of code with something like below for each "Control code" in your Userform

Please Login or Register  to view this content.

Excellent, thanks MickG, got it working now

Thanks again for your help

Twaddy