You can always add the prefix ID letters in the Enter event for the textbox control.
Most people typically validate the whole entry and then format it for input into the sheet. My earlier code just formatted the result assuming that the user entered data in one format. It did not check that the first three characters were letters.
This code validates each character as it is entered. It then modified the entry according to what I think you wanted for the format.
You can add some other Subs to make it more concise and/or add some Case Selects.
Add this to the top line of the Userform code:
This is the exit event. You might want to add a part to make your other textbox Visible property equal False or Locked equals True if Len(TextBox9.Value)=21.
Here is the main part for Textbox9's Change event. Once your understand how it works, I would recommend that you clean it up and modularize it. When you see lots of similar IF's like this, Select Case and support Subs are usually a good idea. I generally do it the IF method until I see the repetitive pattern.
You can use the same concepts in your other textbox. I also made each letter upper case.
LinkBack URL
About LinkBacks
Register To Reply
below the post.
It is userform1 specifically TextBox9 & TextBox14 that I need to be formated as reflected by the examples above the TextBox windows themselves. If that can be accomplished I need one other favor. I need to adjust the following code too, so that if either TextBox9 or if TextBox14 has data in it, it will put the textbox with data in column 5. i.e. Only one of those forms of ID can be used not both and whichever one has data needs to be put in column 5 on my data tab. I hope that makes sense. This is what I have but it isn't working quite right..
Bookmarks