LineFormat.EndArrowheadStyle Property

  • Article
Excel Developer Reference

Returns or sets the style of the arrowhead at the end of the specified line. Read/write MsoArrowheadStyle.

Syntax

expression.EndArrowheadStyle

expression   A variable that represents a LineFormat object.

Remarks

MsoArrowheadStyle can be one of these MsoArrowheadStyle constants.
msoArrowheadNone
msoArrowheadOval
msoArrowheadStyleMixed
msoArrowheadDiamond
msoArrowheadOpen
msoArrowheadStealth
msoArrowheadTriangle

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