Border Property

Microsoft Excel Visual Basic

Represents the visibility options for the border of the object. Read/write MsoTriState.

MsoTriState can be one of these MsoTriState constants.
msoCTrue Does not apply to this object.
msoFalse Sets the border invisible.
msoTriStateMixed Does not apply to this object.
msoTriStateToggle Allows the user to switch the border from visible to invisible and vice versa.
msoTrue default. Sets the border visible.

expression.Border

expression    Required. An expression that returns a CallFormat object.

ShowBorder property as it applies to all other objects in the Applies To list.

Returns a Border object that represents the border of the object.

expression.Border

expression    Required. An expression that returns all other objects in the Applies To list.

Example

This example sets the color of the chart area border of Chart1 to red.

Charts("Chart1").ChartArea.Border.ColorIndex = 3