If IsDate(TextBox1.Text) = False Then
MsgBox "Enter a valid Date in format MM/DD/YYYY"
Exit Sub
End If
--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Use ISDATE() which return True if valid date

If this post helps click Yes
---------------
Jacob Skaria


"Ueli Werner" wrote:

Hi newsgroup

In my excel form I have a textbox where a date value can be entered. When I
enter a wrong value excel crashes.

Now I like to validate this entry with some kind of entry mask. I like to
verify that the entered value cannot be someting other than a date?

Is there a possibility to do this in excel?

Thanks alot

Ueli Werner