Checking Date Input

[GogsJames]

Please bear with a beginner.

I want to check that the date input into a textboxt is entered as the month then days. I have tried to do it by putting this code into the textbox but it does nothing. can anyone help please?

Private Sub txtInvDate_Change()
Dim M(13 To 31) As String

If InStr(1, txtInvDate.Text, "M") Then
MsgBox "Month First Please"
Exit Sub
End If
txtInvDate.SetFocus

End Sub

[Carim]

Hi,

Have you tried the function isDate()

Please Login or Register  to view this content.

HTH
Carim

[GogsJames]

Sorry Carim, as I said, I'm a beginner. Wouldn't know where to start with that function.