Validate User form text box

[tiredofit]

The code below checks for the value entered into the textbox.

Private Sub Date_Change()

    If Not IsDate(Date.Value) Then
        
        MsgBox "Must be a date"
    
    End If
    
End Sub

The problem is whenever the user attempts to enter a date, such as 01/01/2018, as soon as 0 is typed, the code above starts and the MsgBox is displayed.

How can I change it so the above code only starts when the full date have been entered?

Application.EnableEvents = False

does NOT suppress the above.

Thanks

 

[RoryA]

Use the Exit or AfterUpdate event of the textbox instead of the Change event.

 

[tiredofit]

Thanks, works well.

BTW, what's the difference between AfterUpdate and Exit?

 

[RoryA]

Exit is fired every time you leave the control, whether or not it was changed.

 

[tiredofit]

Thanks