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