ArrowHeadLength Property

Applies To

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

Description

Returns or sets the length of the arrow head (one of xlShort, xlMedium, or xlLong). Read-write.

See Also

ArrowHeadStyle 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