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