Pages in this article
-
Preparations
-
Class Module
-
Hooking up
-
Conclusion
Conclusion
As shown in this article it is possible to replace a multitude of
event subroutines by a single class module in combination with an
initialisation routine. This is particularly useful when one has a
multitude of controls on a single form or worksheet and wants to perform
similar actions on a specific event of each control.
Unfortunately, not all events we are used to get are available when
we use this method. Some missing events are quite crucial, such as the
AfterUpdate event for a textbox.
A sample file can be downloaded
here.