What is the best way to validate a TextBox for Date input using VBA?

Charly O

New Member

Join Date: Dec 2010

Posts: 1
#1

What is the best way to validate a TextBox for Date input using VBA?

Dec 12 '10, 02:53 PM

What is the best way to validate a TextBox for Date input using VBA. How to code date inputmask in vba
Tags: vb6, vba

Guido Geurs

Recognized Expert Contributor

Join Date: Oct 2009
Posts: 767

Dec 13 '10, 05:57 PM

Code:

Private Sub CommandButton1_Click()
   If TextBox1 = vbNullString Then Exit Sub
   If IsDate(TextBox1) Then
     TextBox1 = Format(TextBox1, "Short Date")
   Else
     MsgBox "Non valid date"
     Cancel = True
   End If
End Sub

What is the best way to validate a TextBox for Date input using VBA?

What is the best way to validate a TextBox for Date input using VBA?

Comment