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.
Syntax
expression .SetSegmentType(Index, SegmentType)
expression A variable that represents a ShapeNodes object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
---|---|---|---|
Index |
Required |
Long |
The node whose segment type is to be set. |
SegmentType |
Required |
Specifies if the segment is straight or curved. |
Example
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