SelectionType Property

  • Article

ChartSelectionsEnum

ChartSelectionsEnum can be one of these ChartSelectionsEnum constants.
chSelectionAxis
chSelectionCategoryLabel
chSelectionChart
chSelectionChartSpace
chSelectionDataLabel
chSelectionDataLabels
chSelectionDropZone
chSelectionErrorbars
chSelectionField
chSelectionGridlines
chSelectionLegend
chSelectionLegendEntry
chSelectionNone
chSelectionPlotArea
chSelectionPoint
chSelectionSeries
chSelectionSurface
chSelectionTitle
chSelectionTrendline
chSelectionUserDefined

PivotTable object: Returns a String that represents the type of object currently selected in the PivotTable list. Read-only.

expression.SelectionType

*expression   * Required. An expression that returns a ChartSpace or PivotTable object.

Example

The procedure in this example runs whenever the selection in the chart workspace changes. If the user selects an axis, the procedure displays the minimum and maximum values for the axis.

Sub ChartSpace1_SelectionChange()

   Dim chConstants
   Dim minval
   Dim maxval

   Set chConstants = ChartSpace1.Constants

   If ChartSpace1.SelectionType = chConstants.chSelectionAxis Then

      minval = ChartSpace1.Selection.Scaling.Minimum

      maxval = ChartSpace1.Selection.Scaling.Maximum

      MsgBox "minimum = " & minval & " maximum = " & maxval
   End If

End Sub

Applies to | ChartSpace Object | PivotTable Object

See Also | Select Method | Selection Property | SelectionChange Event | SelectionChanging Event