Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What events can be captured in a Class Module?
If you are talking about using With Events, you can use the events native to
the MSForms control (Listbox, combobox, textbox, etc). However, events like Enter, Exit, AfterUpdate and BeforeUpdate belong to the container (the control object) and aren't available using With Events. Likewise for GotFocus and LostFocus which belong to the container (oleObject) on the worksheet. -- Regards, Tom Ogilvy Julian Milano wrote in message ... Like the subject says....... Is there a list of which events for which type of controls are available to a Classs Module? I'm looking at textboxes at the moment.... -- Julian Milano |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
What events can be captured in a Class Module?
Thanks Tom,
So is there *anyway* to capture all the AfterUpdate and BeforeUpdate events of many textboxes or do we have to write a routine for each? -- Julian Milano "Tom Ogilvy" wrote in message ... If you are talking about using With Events, you can use the events native to the MSForms control (Listbox, combobox, textbox, etc). However, events like Enter, Exit, AfterUpdate and BeforeUpdate belong to the container (the control object) and aren't available using With Events. Likewise for GotFocus and LostFocus which belong to the container (oleObject) on the worksheet. -- Regards, Tom Ogilvy Julian Milano wrote in message ... Like the subject says....... Is there a list of which events for which type of controls are available to a Classs Module? I'm looking at textboxes at the moment.... -- Julian Milano |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
What events can be captured in a Class Module?
In the routine for each control, instead of doing the "real work", you can call another sub that
does that. On Mon, 8 Sep 2003 12:46:58 +1000, "Julian Milano" wrote: Thanks Tom, So is there *anyway* to capture all the AfterUpdate and BeforeUpdate events of many textboxes or do we have to write a routine for each? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
What events can be captured in a Class Module?
Not that I am aware of. Someone else may have a different opinion, but I
have never seen a method posted here. -- Regards, Tom Ogilvy Julian Milano wrote in message ... Thanks Tom, So is there *anyway* to capture all the AfterUpdate and BeforeUpdate events of many textboxes or do we have to write a routine for each? -- Julian Milano "Tom Ogilvy" wrote in message ... If you are talking about using With Events, you can use the events native to the MSForms control (Listbox, combobox, textbox, etc). However, events like Enter, Exit, AfterUpdate and BeforeUpdate belong to the container (the control object) and aren't available using With Events. Likewise for GotFocus and LostFocus which belong to the container (oleObject) on the worksheet. -- Regards, Tom Ogilvy Julian Milano wrote in message ... Like the subject says....... Is there a list of which events for which type of controls are available to a Classs Module? I'm looking at textboxes at the moment.... -- Julian Milano |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
What events can be captured in a Class Module?
Thanks Tom & Myrna,
I think Myrna's idea will have to be the best bet for now. -- Julian Milano "Myrna Larson" wrote in message ... In the routine for each control, instead of doing the "real work", you can call another sub that does that. On Mon, 8 Sep 2003 12:46:58 +1000, "Julian Milano" wrote: Thanks Tom, So is there *anyway* to capture all the AfterUpdate and BeforeUpdate events of many textboxes or do we have to write a routine for each? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating UDF by Class Module (Leo)? | Excel Discussion (Misc queries) | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
please give an example of a class module. | Excel Programming | |||
how to declare a class module | Excel Programming |