8Event Programming

Levels of Events

Earlier in the book you saw mention of workbook events and have seen examples of worksheet events. Events are Excel's way of letting you execute code based on certain actions that take place in a workbook.

These events can be found at the following levels:

Application level—Control based on application actions, such as Application_NewWorkbook

Workbook level—Control based on workbook actions, such as Workbook_Open

Worksheet level—Control based on worksheet actions, such as Worksheet_SelectionChange

Chart sheet level—Control based on chart actions, ...

Get VBA and Macros for Microsoft Excel now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.