O'Reilly logo

Business Solutions VBA and Macros for Microsoft 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

Chapter 9. Event Programming

IN THIS CHAPTER

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

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