9. Event Programming

Levels of Events

Earlier in the book, you read about workbook events and you 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 such as Chart_Activate

Listed ...

Get VBA and Macros: Microsoft® Excel® 2010 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.