UserForm Textbox Specific Format

Please can somebody help me.

I have created a UserForm in Excel which is complete apart from one small problem.

I have a text box into which I want the user to enter only 16 characters and I have set the max length property for this. But I also would like the data to be entered as follows, 3 Alpnumeric characters, 12 numeric characters, a “-“ and then 4 numeric characters e.g. AB-20101216-0001

If the data input does not match this criteria then a message box should appear.

Thank you.

Originally Posted by AlexRoberts

Because I want to make things neat and tidy is there a way to postion the cursor back to the beginning of the string when the input does not match the criteria.

Yes you can, Set the focus to the textbox.
Try Adding this (see below) and see if that works for you.

Please Login or Register  to view this content.

hi,

In addition to Stephen's & John's suggestions, try playing around with the "textbox1.sel..." properties, for example:

Please Login or Register  to view this content.

hth
Rob

I prefer not to bother users with messageboxes as if they did something 'wrong'. It also slows the ease with which a user uses your application.

Based on the example in your first post:

Please Login or Register  to view this content.