O'Reilly logo

VBA and Macros for Microsoft Excel by Tracy Syrstad, Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required