LineFormat.EndArrowheadLength Property (Excel)
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.
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