Select Event

Microsoft Excel Visual Basic

Select Event

       

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