| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Global event handler??
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Global event handler??
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where is the workbook_open event handler??? | Excel Programming | |||
| different IDispatch in event handler | Excel Programming | |||
| Cell Event Handler | Excel Programming | |||
| Re : Excel event handler Worksheet_SelectionChange | Excel Programming | |||
| Re : Excel event handler Worksheet_SelectionChange | Excel Programming | |||
Linear Mode
