Select Event [Excel 2003 VBA Language Reference]

  • Article

Occurs when a chart element is selected.

Private Subobject**_Select(ByValElementIDAs Long**, ByValArg1As Long, ByValArg2As Long)

objectChart or an object of type Chart declared with events. For more information, see Using Events with Embedded Charts .

ElementID, Arg1, Arg2 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.

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

Applies to | Chart Object