Microsoft Office Tutorials and References
In Depth Information
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.
continued
Search JabSto ::




Custom Search