Business Solutions VBA and Macros for Microsoft® Office Excel® 2007

Chapter 9. Event Programming

IN THIS CHAPTER

Levels of Events	155
Using Events	156
Workbook Events	157
Worksheet Events	163
Quickly Entering Military Time into a Cell	166
Chart Sheet Events	167
Application-Level Events	171
Next Steps	175

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