Skip to main content

Application.SheetSelectionChange event

Table of contents
  1. Syntax
  2. Parameters

Occurs when the selection changes on any worksheet (doesn't occur if the selection is on a chart sheet).

Syntax

expression.SheetSelectionChange (ShTarget)

expression An expression that returns an Application object.

Parameters

Name Required/Optional Data type Description
Sh Required Object The worksheet that contains the new selection.
Target Required Range The new selected range.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>