How to check Date input

[lehainam]

Dear all,

I am creating a form in Excel for user to input data. In my form, there are many textbox. One of textbox is date input that I would like user to input date format dd/mm/yyyy. Is there any code that can check user's input on this textbox.

Thank you very much.

Nam

[Leith Ross]

Hello Nam,

Use this code...

If IsDate(TextBox1.Value) = False Then
<Execute code for non date entry>
End If

Sincerely,
Leith Ross