You could use this Exit event code for the TextBox (assumed to be named
TextBox1 for this example)...

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If Len(TextBox1.Text) 0 And Len(TextBox1) < 5 Then
Cancel = True
MsgBox "Your entry must be at least 5 characters long."
End If
End Sub

As written, the code allows the user to exit the TextBox if there is no
entry in it (that is what the 0 test provides for).

--
Rick (MVP - Excel)


"sam" wrote in message
...
how do we restrict user to input minimun characters in a text box on
userform.

for eg. I want to make zip code field such that users need to input atlest
5
characters, and not anything less then that.

thanks in advance