Bewerken

Delen via

Chart.Select event (Excel)

  • Artikel

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.