Setting minimum value in text box 1

[smurf01]

In Excel you can set the maximum number of characters in a text box. Is there anyway to set a minimum value also

i.e. i want a text box to only accept six numbers or letters Regards

Paul

 

[RobBroekhuis]

You can validate upon triggering the exit event for the textbox. You could even pre-fill the text with whatever the proper form for the field is (e.g. 000000) and use the change event to adjust the field after each key entry. Exactly how depends on your application.
Rob

 

[smurf01]

Rob,
How would I validate the exit event please ?? Regards

Paul

 

[RobBroekhuis]

In a crude form, something like:

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If Len(TextBox1) <> 6 Then
MsgBox &quot;This field needs to be exactly 6 characters&quot;
Cancel = True
End If
End Sub
Rob

 

[smurf01]

Rob,
Excellent Thank You Regards

Paul