SelectionType Property
TOC
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

SelectionType Property

Office 2003

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

		




Show:
© 2016 Microsoft