I have a userform in which users can write their activities. It has therefore two hour entries (textboxes with format hh:mm). The first one "Van" specifies the time the activity begun. The second one "Tot" specifies the time the activity ended. Users can fill in 10 activities in total. The textbox "Van" is filled in automatically.

Now I need an extra check on the textbox "Tot". It has to check that "Tot" is later than "Van".

How can I do that?

Private Sub Tot_Exit(ByVal Cancel As MSForms.ReturnBoolean)

    If Not IsDate(Tot) And Tot <> vbNullString Then
        MsgBox "Geen geldige tijd"
        Cancel = True
    Else
        Tot = Format(Tot, "hh:mm")
    End If

EnableSave

End Sub