Office® XP Development with VBA

Events in Excel

Most of the events you will be working with occur at the level of the Workbook, Worksheet, or Chart objects. A good number of the events are detected by two or three of these objects, so you have a great deal of flexibility as to how you use the events. Table 6.12 describes those events that are detected by two or all three of these objects.

Table 6.12. Events detected by two or three of the Workbook, Worksheet, and Chart objects.

Event	Detected by	Description
Activate	Ch, Wb, Ws	Occurs when the object is activated.
BeforeDoubleClick	Ch, Ws	Occurs when the object is double-clicked, before the default double-click event.
BeforeRightClick	Ch, Ws	Occurs when the object is right-clicked, before the default right-click event.
Calculate	Ch, Ws	Occurs ...