Parent Property

Returns the parent object for the specified object.

expression.Parent

*expression   * Required. An expression that returns one of the objects in the Applies To list.

Example

The event procedure in this example runs whenever the user clicks in the chart workspace.

Sub ChartSpace1_Click()

   Dim chConstants
   Dim iSeriesNum
   Dim iPointNum

   Set chConstants = ChartSpace1.Constants

   If ChartSpace1.SelectionType = chConstants.chSelectionPoint Then
      ' Point parent is series.
      iSeriesNum = ChartSpace1.Selection.Parent.Index

      iPointNum = ChartSpace1.Selection.Index

      MsgBox "Series: " & iSeriesNum & " Point: " & iPointNum
   End If

End Sub

Applies to | AutoFilter Object | Border Object | Borders Collection Object | ChartSpace Object | ChAxes Collection | ChAxis Object | ChBorder Object | ChCategoryLabel Object | ChCategoryLabels Collection Object | ChChart Object | ChChartField Object | ChChartFields Object | ChCharts Collection | ChDataLabel Object | ChDataLabels Object | ChDataLabelsCollection Collection | ChDropZone Object | ChErrorBars Object | ChErrorBarsCollection Object | ChGridlines Object | ChLegend Object | ChLegendEntries Collection | ChLegendEntry Object | ChPlotArea Object | ChPoint Object | ChPoints Collection | ChSegments Object | ChSelectionCollection Collection | ChSeries Object | ChSeriesCollection Collection Object | ChSurface Object | ChTitle Object | ChTrendline Object | ChTrendlines Collection | ChUserDefinedSelection Object | Criteria Object | Filter Object | Filters Collection Object | Font Object | Heading Object | Headings Object | Hyperlink Object | Interior Object | ListObject Object | ListObjects Collection | ListRow Object | ListRows Collection | Name Object | Names Collection | Pane Object | Panes Collection Object | PivotHyperlink Object | PivotTable Object | Protection Object | Range Object | Sheets Collection | TitleBar Object | Window Object | Windows Collection Object | Workbook Object | Workbooks Collection | Worksheet Object | Worksheets Collection Object | XmlDataBinding Object | XmlDataBindings Collection | XmlMap Object | XmlMaps Collection