Limit Userform TextBox Characters

Hi,

I am using Excel 2000.

I have userform which contains a text box, I would like to limit the number of characters entered into the text box.

For example
I would like users to only be able to enter 25 characters into txtName, when they try and enter the 26th character I don't want it to appear in the text box.

Any ideas would be great
Thanks
Jennie

Go to the properties for the textbox, set the MaxLength property to 25

- Mangesh

Thanks for your help
That works wonderfully

Thanks again
Jennie

Hi Mangesh,

How would I do the same action in excel 2003?