John Walkenbach demonstrates the technique with commandbuttons, but you can
adapt it to textboxes for the keypress events

http://j-walk.com/ss/excel/tips/tip44.htm
Handle Multiple UserForm Buttons With One Subroutine

this approach won't work for events provided by the Control Object such as
Exit and BeforeUpdate as examples.

--
Regards,
Tom Ogilvy



wrote in message
...
Hi all news group readers,
I have the following problem:
In a user form, within a Multipage I have 567 TextBoxes.
I need to handle keypress events for all of them in a global manner
since I don't want to clutter my code with 567 subs.
Can anyone tell me if this is possible?
Thanks