ArrowHeadStyle Property

Applies To

DrawingObjects Collection, GroupObject Object, GroupObjects Collection, Line Object, Lines Collection.

Description

Returns or sets the arrow head type (one of xlNone, xlOpen, xlClosed, xlDoubleOpen, or xlDoubleClosed). Read-write.

See Also

ArrowHeadLength Property, ArrowHeadWidth Property.

Example

This example creates a new line on Sheet1 and then sets the arrowhead length, width, and style.

Set newLine = Worksheets("Sheet1").Lines.Add(72, 72, 144, 144)
With newLine
    .ArrowHeadLength = xlShort
    .ArrowHeadWidth = xlNarrow
    .ArrowHeadStyle = xlOpen
End With