Page 303 - Microsoft Office Excel 2003 Programming Inside Out

Understanding and Using Events

Table 12-3 describes the commonly used Application events that can be programmed in your
workbooks.

Table 12-3. Commonly Monitored Events by the Application Object
Event Action That Triggers the Event
NewWorkbook Monitors the NewWorkbook event for the Excel application.
The event is triggered when a new workbook is created.
SheetActivate Monitors the SheetActivate event for the entire Excel program. The
event is triggered when any sheet is activated within the program.
WorkbookOpen Monitors the WorkbookOpen event for the Excel application.
The event is triggered when any workbook is opened within the
Excel window.

Inside Out

Locate Events Using the Object Browser
The Object Browser is a useful tool that can help you learn about objects, their properties,
and their methods. The Object Browser is also useful when trying to find which objects are
supported by a particular event. For example, say you would like to find out which objects
support the Change event. Activate the Visual Basic Editor, and press F2 to display the
Object Browser window. Make sure <All Libraries> is selected, and then type Change and
click the binoculars icon, as shown in the following graphic.

Chapter 12

continued

277
Part 4: Advanced VBA