ShapeNodes.SetEditingType Method

  • Article
Excel Developer Reference

Sets the editing type of the node specified by Index. If the node is a control point for a curved segment, this method sets the editing type of the node adjacent to it that joins two segments. Note that, depending on the editing type, this method may affect the position of adjacent nodes.

Syntax

expression.SetEditingType(Index, EditingType)

expression   A variable that represents a ShapeNodes object.

Parameters

Name Required/Optional Data Type Description
Index Required Long The node whose editing type is to be set.
EditingType Required MsoEditingType The editing property of the vertex.

Example

This example changes all corner nodes to smooth nodes in shape three on myDocument. Shape three must be a freeform drawing.

Visual Basic for Applications 
  Set myDocument = Worksheets(1)
With myDocument.Shapes(3).Nodes
    For n = 1 to .Count
        If .Item(n).EditingType = msoEditingCorner Then
            .SetEditingType n, msoEditingSmooth
        End If
    Next
End With

See Also