Use a text box from the Controls toolbox which has a MaxLength property.

NickHK

"mastermind" wrote in message
ups.com...
I placed a textbox on my worksheet using the drawing toolbar, and
would like to limit the number of characters that can be entered. As
of right now the textbox allows the user to input more characters than
it can actually display. Does anyone know how to limit the number of
characters to avoid this problem?

John