Microsoft Office Tutorials and References
In Depth Information
In Figure 12-3, you can see how to create a new Worksheet event procedure.
Figure 12-3. This is how to create a new Worksheet event procedure.
After you have created the new event procedure, you’ll notice the Private Sub
Worksheet_Event and End Sub code has been added to the code window. Table 12-2
describes the commonly used Wo rksheet events.
Table 12-2. Commonly Used Worksheet Events
Worksheet Event
Action That Triggers Event
Change
Monitors the Change event for the worksheet. The event is
triggered when the cells of the worksheet are changed by the user
or by an external link.
Selection Change
Monitors the SelectionChange event for the worksheet. The
event is triggered when the user chooses a new selection on
the worksheet.
BeforeRightClick
Monitors the BeforeRightClick event for the worksheet. The event
is triggered when the user right-clicks the worksheet.
Note To navigate to the event procedures in a worksheet, you can right-click the sheet
tab in the Excel program window and select View Code.
Search JabSto ::




Custom Search