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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.