Border Property

Microsoft Excel Visual Basic

Show All

Border Property

       

Border property as it applies to the CalloutFormat object.

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.

Border 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