title: allow only numbers and slash in textbox vba
body: <p>The following code allows only numbers to be typed in <code>TextBox1</code>. But <code>TextBox1</code> is for insertion of history (Date) and I want to with format "0000/00/00". How can I exclude "/" from <code>IsNumeric</code> In the error message?</p>
  
  <pre><code>Private Sub textbox1_Change()
  If Not IsNumeric(TextBox1.Value) Then
     MsgBox "only numbers allowed"
     With TextBox1
    .SetFocus
    .SelStart = 0
    .SelLength = Len(.Text)
     End With
  End If
  Dim strTemp As String
  If TextBox1.TextLength = 8 Then
    Me.TextBox1.Value = Format(Me.TextBox1.Value, "0000/00/00")
  End If
  End Sub
  </code></pre>