Clara,

You can do it by defining a textbox class. This example is for buttons, but
can be modified:

http://www.j-walk.com/ss/excel/tips/tip44.htm

hth,

Doug

"clara" wrote in message
...
Hi all,

In a form, there are 30 textboxes who all need the limitation of 30 chars
in
length. I know code can be put in the change event, but if I do it in that
way, I will use 30 event handlers even I can abstract the core logic into
a
sub.Is there a way to use one handler for all text box controls

Clara
--
thank you so much for your help