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
|