title: Set date format as dd-mmm-yyyy in activex textbox VBA
body: <p>Is there a way to set date format as <code>dd-mmm-yyyy</code> in ActiveX TextBox?</p>
  
  <p>I'm using the code below to separate the quote but there is one error while user is putting month., i.e. 31-May-1993 but sometimes user is putting 31-may-2015. </p>
  
  <p>Because of that unable to fetch the data through server...</p>
  
  <pre><code>Private Sub TextBox1_Change()
      If TextBox1.TextLength = 2 Or TextBox1.TextLength = 6 Then
      TextBox1.Text = TextBox1.Text + "-"
      End If
  End Sub
  </code></pre>