_OLEObject.OnAction Property
Returns or sets the name of a macro that’s run when the specified object is clicked. Read/write String.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property OnAction As String
Get
Set
'Usage
Dim instance As _OLEObject
Dim value As String
value = instance.OnAction
instance.OnAction = value
string OnAction { get; set; }
Property Value
Type: System.String
Remarks
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.
Examples
This example causes Microsoft Excel to run the ShapeClick procedure whenever shape one is clicked.
Worksheets(1).Shapes(1).OnAction= "ShapeClick"