Skip to main content

Shape.OnAction property

Table of contents
  1. Syntax
  2. Remarks
  3. Example

Returns or sets the name of a macro that's run when the specified object is chosen. Read/write String.



expression A variable that represents a Shape object.


Setting this property for a menu item overrides any custom help information set up for the menu item with the information set up for the assigned macro.


This example causes Microsoft Excel to run the ShapeClick procedure whenever shape one is chosen.

Worksheets(1).Shapes(1).OnAction = "ShapeClick"

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>