Validation in a userform

[Craig AS]

How would I validate a userform text box, so there cn only be 4-8 characters in it? Thanks alot for any help.

 

[Bruno_x]

set the property MaxLength of your textbox to 4 or 8
If the text must be -at least- 4 characters, you can controle the textlength with something like this :

if userform1.TextBox1.TextLength< 4 then
   msgbox "The text is too short."
end if

This message was edited by Bruno on 2002-03-08 04:42