Edit

ShapeNode.Points property (Excel)

  • Article

Returns the position of the specified node as a coordinate pair. Each coordinate is expressed in points. Read-only Variant.

Syntax

expression.Points

expression An expression that returns a ShapeNode object.

Return value

Variant

Remarks

This property is read-only. Use the SetPosition method to set the value of this property.

Example

This example moves node two in shape three on myDocument to the right 200 points and down 300 points. Shape three must be a freeform drawing.

Set myDocument = Worksheets(1) 
With myDocument.Shapes(3).Nodes 
 pointsArray = .Item(2).Points 
 currXvalue = pointsArray(1, 1) 
 currYvalue = pointsArray(1, 2) 
 .SetPosition 2, currXvalue + 200, currYvalue + 300 
End With

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.