Editing date in textbox?

  • Thread starter Thread starter Don Wiss
  • Start date Start date
D

Don Wiss

When a date is required in a spreadsheet cell it is real easy to use Data
Validation. But if input is being entered in a Form, one only has a
textbox. (I am not interested in any date input control, as nothing is
easier to input than simply typing a date.) I don't see any easy way to
edit that the date is valid. I am planning to try assigning the input to a
date data type and capturing any errors. Is there any other way?

Thanks, Don <donwiss at panix.com>.
 
Hi Don,

You will have to use the 'IsDate' funcion:

If IsDate(TextBox1) = False Then
MsgBox "Not a valid date."
Else
MsgBox "Valid date"
End If
 
You will have to use the 'IsDate' funcion:

If IsDate(TextBox1) = False Then
MsgBox "Not a valid date."
Else
MsgBox "Valid date"
End If
Click to expand...

Thank you. I was not aware of Isdate. I will try this tomorrow at work, and
hope that it exists in Excel 97.

Don <donwiss at panix.com>.
 
Back
Top