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