Select Event

Microsoft Excel Visual Basic

Occurs when a chart element is selected.

Private Sub object_Select(ByVal ElementID As Long, ByVal Arg1 As Long, ByVal Arg2 As Long)

object    Chart or an object of type Chart declared with events in a class module. 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