Skip to content

Latest commit

 

History

History
57 lines (32 loc) · 1.35 KB

0d9eaff5-3ebc-572c-e188-d39848fa9bd2.md

File metadata and controls

57 lines (32 loc) · 1.35 KB

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

See also

Concepts

LineFormat Object

Other resources

LineFormat Object Members