title: Formatting MM/DD/YYYY dates in textbox in VBA
body: <p>I'm looking for a way to automatically format the date in a VBA text box to a MM/DD/YYYY format, and I want it to format as the user is typing it in. For instance, once the user types in the second number, the program will automatically type in a "/". Now, I got this working (as well as the second dash) with the following code:</p>
  
  <pre><code>Private Sub txtBoxBDayHim_Change()
      If txtBoxBDayHim.TextLength = 2 or txtBoxBDayHim.TextLength = 5 then
      txtBoxBDayHim.Text = txtBoxBDayHim.Text + "/"
  End Sub
  </code></pre>
  
  <p>Now, this works great when typing. However, when trying to delete, it still enters in the dashes, so its impossible for the user to delete past one of the dashes (deleting a dash results in a length of 2 or 5, and the sub is then run again, adding in another dash). Any suggestions on a better way to do this?</p>