LineFormat Members (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Represents line and arrowhead formatting.

Properties

Name

Description

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.

BackColor

Returns or sets a ColorFormat object that represents the specified fill background color.

BeginArrowheadLength

Returns or sets the length of the arrowhead at the beginning of the specified line. Read/write MsoArrowheadLength.

BeginArrowheadStyle

Returns or sets the style of the arrowhead at the beginning of the specified line. Read/write MsoArrowheadStyle.

BeginArrowheadWidth

Returns or sets the width of the arrowhead at the beginning of the specified line. Read/write MsoArrowheadWidth.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

DashStyle

Returns or sets the dash style for the specified line. Can be one of the MsoLineDashStyle contants. Read/write Long.

EndArrowheadLength

Returns or sets the length of the arrowhead at the end of the specified line. Read/write MsoArrowheadLength.

EndArrowheadStyle

Returns or sets the style of the arrowhead at the end of the specified line. Read/write MsoArrowheadStyle.

EndArrowheadWidth

Returns or sets the width of the arrowhead at the end of the specified line. Read/write MsoArrowheadWidth.

ForeColor

Returns or sets a ColorFormat object that represents the specified foreground fill or solid color.

InsetPen

Returns or sets whether lines are drawn inside the specified shape's boundaries. Read/write

Parent

Returns the parent object for the specified object. Read-only.

Pattern

Returns or sets an MsoPatternType value that represents the fill pattern.

Style

Returns or sets a MsoLineStyle value that represents the style of the line.

Transparency

Returns or sets the degree of transparency of the specified fill as a value from 0.0 (opaque) through 1.0 (clear). Read/write Double.

Visible

Returns or sets a MsoTriState value that determines whether the object is visible. Read/write.

Weight

Returns or sets a Single value that represents the weight of the line.