Share via

LineFormat.EndArrowheadLength Property

  • Article
Excel Developer Reference

Returns or sets the length of the arrowhead at the end of the specified line. Read/write MsoArrowheadLength.

Syntax

expression.EndArrowheadLength

expression   A variable that represents a LineFormat object.

Remarks

MsoArrowheadLength can be one of these MsoArrowheadLength constants.
msoArrowheadLengthMixed
msoArrowheadShort
msoArrowheadLengthMedium
msoArrowheadLong

Example

This example adds a line to myDocument. There’s a short, narrow oval on the line's starting point and a long, wide triangle on its end point.

Visual Basic for Applications 
  Set myDocument = Worksheets(1)
With myDocument.Shapes.AddLine(100, 100, 200, 300).Line
    .BeginArrowheadLength = msoArrowheadShort
    .BeginArrowheadStyle = msoArrowheadOval
    .BeginArrowheadWidth = msoArrowheadNarrow
    .EndArrowheadLength = msoArrowheadLong
    .EndArrowheadStyle = msoArrowheadTriangle
    .EndArrowheadWidth = msoArrowheadWide
End With

See Also