Chart.Select Event

Excel Developer Reference

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 these arguments, see the BeforeDoubleClick event.
Arg1 Required Long The selected chart element. For more information about these arguments, see the BeforeDoubleClick event.
Arg2 Required Long The selected chart element. For more information about these arguments, see the BeforeDoubleClick event.

Example

This example displays a message box if the user selects the chart title.

Visual Basic for Applications
  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

See Also