DiagramNodes Collection [Excel 2003 VBA Language Reference]
Diagram DiagramNodes DiagramNode Multiple objects |
A collection of DiagramNode objects that represents all the nodes in a diagram.
Using the DiagramNodes collection
Use the Nodes property of the Diagram object to return a DiagramNodes collection. Use the Item method to select and work with a single diagram node in a diagram. This example assumes the first shape in the active worksheet is a diagram, selects the first node, and deletes it.
Sub FillDiagramNode()
ActiveSheet.Shapes(1).Diagram.Nodes.Item(1).Delete
End Sub
Use the SelectAll method to select and work with all nodes in a diagram. This example assumes the first shape in the active worksheet is a diagram, selects all nodes, and fills them with the specified pattern.
Sub FillDiagramNodes()
ActiveSheet.Shapes(1).Diagram.Nodes.SelectAll
Selection.ShapeRange.Fill.Patterned msoPatternSmallConfetti
End Sub
Properties | Application Property | Count Property | Creator Property | Parent Property
Methods | Item Method | SelectAll Method
Parent Objects | Diagram
Child Objects | DiagramNode | DiagramNodeChildren | Shape
See Also | DiagramNode Object | DiagramNode Property | DiagramNodeChildren Collection