Worksheet Events

Name

Parameters

Description

Activate

Triggered when a worksheet is made to have focus

BeforeDouble Click

Target AsRange, Cancel AsBoolean

Triggered just before a user double-clicks a worksheet. The cell closest to the point double-clicked in the worksheet is passed into the event procedure as Target. The double-click action can be canceled by setting the Cancel parameter to True

BeforeRight Click

Target as Range, Cancel AsBoolean

Triggered just before a user right-clicks a worksheet. The cell closest to the point right-clicked in the worksheet is passed into the event procedure as Target. The right-click action can be canceled by setting the Cancel parameter to True

Calculate

Triggered after the worksheet is recalculated

Change

Target As Range

Triggered when the worksheet cell values are changed. The changed range is passed into the event procedure as Target

Name

Parameters

Description

Deactivate

Triggered when the worksheet loses focus

Follow Hyperlink

Target As Hyperlink

Triggered when a hyperlink is clicked on the worksheet. The hyperlink that was clicked is passed into the event procedure as Target

PivotTable Update

ByVal Target As PivotTable

Triggered when a PivotTable report is updated on a worksheet

Selection Change

Target As Range

Triggered when the selection changes in a worksheet. The new selected range is passed into the event procedure as Target

0 0

Post a comment