Parent Property [Excel 2003 VBA Language Reference]

Returns the parent object for the specified object. Read-only.

expression.Parent

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

Example

This example displays the name of the chart that contains myAxis.

Sub DisplayParentName()

    Set myAxis = Charts(1).Axes(xlValue)
    MsgBox myAxis.Parent.Name

End Sub

This example displays the name of the

Visit ListColumn

object containing the

Visit ListDataFormat

object for the third column of a list in Sheet1 of the active workbook.

Sub PrintParentName()
   Dim wrksht As Worksheet
   Dim objListCol As ListColumn
   
   Set wrksht = ActiveWorkbook.Worksheets("Sheet1")
   Set objListCol = wrksht.ListObjects(1).ListColumns(3)

   Debug.Print objListCol.ListDataFormat.Parent
End Sub

Applies to | AddIn Object | AddIns Collection Object | Adjustments Object | Application Object | Areas Collection | AutoCorrect Object | AutoFilter Object | AutoRecover Object | Axes Collection Object | Axis Object | AxisTitle Object | Border Object | Borders Collection | CalculatedFields Collection Object | CalculatedItems Collection Object | CalculatedMember Object | CalculatedMembers Collection | CalloutFormat Object | CellFormat Object | Characters Object | Chart Object | ChartArea Object | ChartColorFormat Object | ChartFillFormat Object | ChartGroup Object | ChartGroups Collection | ChartObject Object | ChartObjects Collection Object | Charts Collection | ChartTitle Object | ColorFormat Object | Comment Object | Comments Collection Object | ConnectorFormat Object | ControlFormat Object | Corners Object | CubeField Object | CubeFields Collection Object | CustomProperties Collection | CustomProperty Object | CustomView Object | CustomViews Collection Object | DataLabel Object | DataLabels Collection Object | DataTable Object | DefaultWebOptions Object | Diagram Object | DiagramNode Object | DiagramNodeChildren Collection | DiagramNodes Collection | Dialog Object | Dialogs Collection Object | DisplayUnitLabel Object | DownBars Object | DropLines Object | Error Object | ErrorBars Object | ErrorCheckingOptions Object | Errors Object | FillFormat Object | Filter Object | Filters Collection Object | Floor Object | Font Object | FormatCondition Object | FormatConditions Collection Object | FreeformBuilder Object | Graphic Object | Gridlines Object | GroupShapes Collection Object | HiLoLines Object | HPageBreak Object | HPageBreaks Collection Object | Hyperlink Object | Hyperlinks Collection | Interior Object | LeaderLines Object | Legend Object | LegendEntries Collection Object | LegendEntry Object | LegendKey Object | LineFormat Object | LinkFormat Object | ListColumn Object | ListColumns Collection | ListDataFormat Object | ListObject Object | ListObjects Collection | ListRow Object | ListRows Collection | Mailer Object | Name Object | Names Collection Object | ODBCError Object | ODBCErrors Collection Object | OLEDBError Object | OLEDBErrors Collection Object | OLEFormat Object | OLEObject Object | OLEObjects Collection Object | Outline Object | PageSetup Object | Pane Object | Panes Collection Object | Parameter Object | Parameters Collection Object | Phonetic Object | Phonetics Collection Object | PictureFormat Object | PivotCache Object | PivotCaches Collection Object | PivotCell Object | PivotField Object | PivotFields Collection Object | PivotFormula Object | PivotFormulas Collection Object | PivotItem Object | PivotItemList Collection | PivotItems Collection Object | PivotLayout Object | PivotTable Object | PivotTables Collection Object | PlotArea Object | Point Object | Points Collection Object | PublishObject Object | PublishObjects Collection Object | QueryTable Object | QueryTables Collection Object | Range Collection | RecentFile Object | RecentFiles Collection Object | RoutingSlip Object | Scenario Object | Scenarios Collection Object | Series Object | SeriesCollection Collection Object | SeriesLines Object | ShadowFormat Object | Shape Object | ShapeNode Object | ShapeNodes Collection Object | ShapeRange Collection | Shapes Collection | Sheets Collection Object | SmartTag Object | SmartTagAction Object | SmartTagActions Collection | SmartTagOptions Object | SmartTagRecognizer Object | SmartTagRecognizers Collection | SmartTags Collection | SoundNote Object | Style Object | Styles Collection | Tab Object | TextEffectFormat Object | TextFrame Object | ThreeDFormat Object | TickLabels Object | TreeviewControl Object | Trendline Object | Trendlines Collection Object | UpBars Object | UsedObjects Collection | Validation Object | VPageBreak Object | VPageBreaks Collection Object | Walls Object | Watch Object | Watches Collection | WebOptions Object | Window Object | Windows Collection Object | Workbook Object | Workbooks Collection | Worksheet Object | WorksheetFunction Object | Worksheets Collection | XmlDataBinding Object | XmlMap Object | XmlMaps Collection | XmlNamespace Object | XmlNamespaces Collection | XmlSchema Object | XmlSchemas Collection | XPath Object