Microsoft KB Archive/151468

= Methods and Properties Used to Create OnEvent Procedures =

Article ID: 151468

Article Last Modified on 10/10/2006

-

APPLIES TO


 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 5.0c
 * Microsoft Excel 5.0 for Macintosh
 * Microsoft Excel 5.0a for Macintosh

-



This article was previously published under Q151468



This article also applies to:
 * Microsoft Excel for Windows 5.0|5.0
 * Microsoft Excel for Windows 5.0c|5.0c
 * Microsoft Excel for the Macintosh 5.0|5.0
 * Microsoft Excel for the Macintosh 5.0a|5.0a



SUMMARY
The following article lists the Visual Basic for Applications Edition methods and properties that are used to create OnEvent procedures in Microsoft Excel.



MORE INFORMATION
Several objects in Microsoft Excel Visual Basic for Applications Edition have certain methods and properties which have an association with certain events. An example of this is clicking an object. Using Visual Basic for Applications, you can make a procedure run when these events occur. The following are the methods and properties, and the events that cause the associated procedures to run.   Methods and Properties             Events That Cause Procedures to Run --            ---

OnAction Property:                Clicking a control or a graphic object, clicking a menu command, or                                     clicking a toolbar button

OnCalculate Property:             Recalculating a worksheet

OnData Property:                  The arrival of data from another application through OLE or DDE

OnDoubleClick Property:           Double-clicking anywhere on a chart sheet, dialog sheet, module or                                     worksheet; clicking border of drawing object or control

OnEntry Property:                 Entering data using the formula bar or editing data in a cell

OnKey Method:                     Pressing a particular key or key combination

OnRepeat Method:                  Clicking Repeat on the Edit Menu

OnSave Property (7.0 only):       Invoking the Save or Save As command

OnSheetActivate Property:         Activating a chart sheet, dialog sheet, module sheet, worksheet, workbook, or Microsoft Excel itself

OnSheetDeactivate Property:       Deactivating a chart sheet, dialog sheet, module, worksheet, workbook, or Microsoft Excel itself

OnTime Method:                    Waiting until a specific time arrives, or waiting for a specified time delay

OnUndo Method:                    Clicking Undo on the Edit Menu

OnWindow Property:                Activating a window For additional information about events in Microsoft Excel 97 and Microsoft Excel 98, please see the following article in the Microsoft Knowledge Base:

161761 XL97: Summary of Workbook and Worksheet Application Events

