title: Apply Regex into a textbox form VBA
body: <p>I need your help guys. How can I limit my textboxes? This is my Form Below.
  <a href="https://i.stack.imgur.com/qWNeG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qWNeG.png" alt="enter image description here"></a></p>
  
  <p>What I need is to create if statement for the following textboxes:
  Pallet ID: Must only contain 9 numbers
  Carton ID: Must only contain 10 numbers
  Serials (all 6): Must startwith FOC and only contain CAPS and Numbers [A-Z][0-9]</p>
  
  <p>I did this in Javascript but now I need to have a backup in a excelsheet. Any ideas?</p>
  
  <p>Thanks for your attention,</p>