Excel VBA UserForm TextBox - Check If Date Is Valid (on exit)

Excel VBA UserForm TextBox - Learn how to check if date is valid (on exit)

The code used in this video:

Private Sub txtDate_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If txtDate = vbEmptyString Then Exit Sub

If IsDate(txtDate) Then
txtDate = Format(txtDate, "dd/mm/yyyy")
Else
MsgBox "Please enter a valid date", vbCritical
End If

End Sub

Видео Excel VBA UserForm TextBox - Check If Date Is Valid (on exit) канала InAnOffice