Geek asks and answers

Subscribe to events at VBA?

Did I understand correctly that you cannot subscribe to an event other than how to use the VBA editor control name + combined event names? Is there no syntax for combobox.change + = eventhandler, as in other languages ​​like C #, is there?

+3
source share
1 answer

Correctly. Event handling is done using the naming convention in VB6 / VBA.
The name may be the name of the itlsef control, or it may be a declared variable WithEvents. Assigning a different link to this variable, you begin to receive events from this new object. This can be seen as a dynamic subscription.

. , Excel , Button.OnAction. ( ), .

+4

More articles:


All Articles