title: How to force the input of a textbox on a userform to be a specific format in VBA
body: <p>I have a user form with a series of input textboxes and am looking for a way to prevent the user from inputing anything other than 5 digits followed by one letter followed by 4 digits. E.g. <em>12345A6789</em></p>
  
  <p>I can see a way to use only numeric and only alphabetic and create three text boxes and then somehow merge them all together- although not sure how to do that either. Ideally there would just be one textbox.  </p>
  
  <p>Any help is appreciated </p>