ShapeNodes.SetSegmentType method (Excel)
Sets the segment type of the segment that follows the node specified by Index. If the node is a control point for a curved segment, this method sets the segment type for that curve. Note that this may affect the total number of nodes by inserting or deleting adjacent nodes.
expression A variable that represents a ShapeNodes object.
|Index||Required||Long||The node whose segment type is to be set.|
|SegmentType||Required||MsoSegmentType||Specifies if the segment is straight or curved.|
This example changes all straight segments to curved segments in shape three on myDocument. Shape three must be a freeform drawing.
Set myDocument = Worksheets(1) With myDocument.Shapes(3).Nodes n = 1 While n <= .Count If .Item(n).SegmentType = msoSegmentLine Then .SetSegmentType n, msoSegmentCurve End If n = n + 1 Wend 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.