VBA Code for Textbox: First 3 characters Alphabets next 3 characters numeric

yeah textbox1 is a required field, i am not quite nderstanding what you mean by random input. I am a noob, very new at this.

This is the current code i have, i have it so that if nothing or less than 10 characters are typed in it will give error message when clicking command "ok" button. But i would like the restrictions to be expanded to how i described above..

If Len(TextBox1.Text) < 10 Then
MsgBox "Please Enter Correct SCN #"
Exit Sub
End If

Originally Posted by Solus Rankin

Are you trying to require input into this textbox in this format?

Would you like random input when the userform initializes?

I think i get your Qs now....

Yes the value would have to be typed in this format. 3 letters, followed by 3 numbers, 1 letter, 3 numbers = example SCN234A098

So it shouldnt be random input..

To a UserForm module

Please Login or Register  to view this content.

thanks so much for the quick replies guys!!!

Solus rankin, yours worked like a charm...