Chart.Select event (Excel)
Occurs when a chart element is selected.
Syntax
expression.Select (ElementID, Arg1, Arg2)
expression An expression that returns a Chart object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| ElementID | Required | Long | The selected chart element. For more information about this argument, see the BeforeDoubleClick event. |
| Arg1 | Required | Long | The selected chart element. For more information about this argument, see the BeforeDoubleClick event. |
| Arg2 | Required | Long | The selected chart element. For more information about this argument, see the BeforeDoubleClick event. |
Example
This example displays a message box if the user selects the chart title.
Private Sub Chart_Select(ByVal ElementID As Long, _
ByVal Arg1 As Long, ByVal Arg2 As Long)
If ElementId = xlChartTitle Then
MsgBox "please don't change the chart title"
End If
End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.