Nodes Property

Microsoft Excel Visual Basic

Show All

Nodes Property

       

Nodes property as it applies to the Diagram object.

Returns a DiagramNodes object that contains a flat list of all the nodes in the specified diagram.

expression.Nodes

expression   Required. An expression that returns a Diagram object.

Nodes property as it applies to the Shape and ShapeRange objects.

Returns a ShapeNodes collection that represents the geometric description of the specified shape. Applies to Shape or ShapeRange objects that represent freeform drawings.

expression.Nodes

expression   Required. An expression that returns one of the above objects.

Example

As it applies to the Shape and ShapeRange objects.

This example adds a smooth node with a curved segment after node four in shape three on myDocument. Shape three must be a freeform drawing with at least four nodes.

Set myDocument = Worksheets(1)
With myDocument.Shapes(3).Nodes
    .Insert 4, msoSegmentCurve, msoEditingSmooth, 210, 100
End With