An Interactive Learning Tool

Proud to be a Teacher


Objects and Subordinates

An object contains events for itself as well as replications of events for its subordinate objects. Since the Worksheet is at the bottom of the hierarchy and has no subordinate objects (at least no objects that have events, that have events), so the Worksheet contains only events for itself. For example, each worksheet has an event named Worksheet_Change that is triggered when a cell on that worksheet is changed either by user input or by VBA (but not if the change is the result of a calculation). Each worksheet's Worksheet_Change event is exclusive to that sheet.


Terms of use Website Policy Contact us
© Copyrights ExcelYourVBA.com 2020