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