Need to set the max character limit of a text box in VBA to 4 digits

Hi

I am creating a user form as part of my Computing Coursework, and one of my text boxes needs to have a limit of how much the user can input it has to no more than 4 character and no less than 4 and they can only be numeric. I tried
If Not Candidate.Value(IsNumeric(txtAmount)) And Not (Len(txtAmount) = 5) Then
MsgBox "The Candidate number is either too short or incorrect"
End If

Even If Candidate.Value < 4 Then
Msg

None of them work they all don't work.

If anyone can help, thanks in advance

think best way is to check before it goes to the textbox
like this

Please Login or Register  to view this content.

Kind regards
Leo