title: Excel VBA verify specific formatting in textbox
body: <p>How can I verify a specific format in a textbox? I am scanning a label into a textbox that contains a date which is formatted like:</p>
  
  <pre><code>mm.dd.yyyy.hh.mm.ss
  </code></pre>
  
  <p>I have tried things that do not work...</p>
  
  <pre><code>If Not Format(TextBox1, "mm.dd.yyyy.hh.mm.ss") Then
  MsgBox "Wrong Format"
  End If
  </code></pre>