Global event handler??

  • Thread starter Thread starter user
  • Start date Start date
U

user

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Writing code to objects within MultiPage object 2
Events (not) disabled 2
QueryClose event of a form triggering Exit event of a textbox on that form 1
UNDO become impossible after modifying SheeChange handler 3
Passing data to an event handler 3
Remaining Numbers from a List that are not used 2
Multipage and Global variables 1
Calling Button click event from Form initialise event? 2

Back
Top