Excel.LineFormat.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
LineFormat object (Excel)	vbaxl10.chm110000	vbaxl10.chm110000	Excel.LineFormat	13eca34b-adf7-ddd3-8c73-cc8b508c624a	03/30/2019	medium

LineFormat object (Excel)

Represents line and arrowhead formatting.

Remarks

For a line, the LineFormat object contains formatting information for the line itself; for a shape with a border, this object contains formatting information for the shape's border.

Example

Use the Line property of the Shape object to return a LineFormat object.

The following example adds a blue, dashed line to myDocument. There's a short, narrow oval at the line's starting point and a long, wide triangle at its end point.

Set myDocument = Worksheets(1) 
With myDocument.Shapes.AddLine(100, 100, 200, 300).Line 
 .DashStyle = msoLineDashDotDot 
 .ForeColor.RGB = RGB(50, 0, 128) 
 .BeginArrowheadLength = msoArrowheadShort 
 .BeginArrowheadStyle = msoArrowheadOval 
 .BeginArrowheadWidth = msoArrowheadNarrow 
 .EndArrowheadLength = msoArrowheadLong 
 .EndArrowheadStyle = msoArrowheadTriangle 
 .EndArrowheadWidth = msoArrowheadWide 
End With

Properties

• Application
• BackColor
• BeginArrowheadLength
• BeginArrowheadStyle
• BeginArrowheadWidth
• Creator
• DashStyle
• EndArrowheadLength
• EndArrowheadStyle
• EndArrowheadWidth
• ForeColor
• InsetPen
• Parent
• Pattern
• Style
• Transparency
• Visible
• Weight

See also

• Excel Object Model Reference

[!includeSupport and feedback]