Class DataBarBorder (Excel VBA)

The class DataBarBorder represents the border of the data bars specified by a conditional formatting rule. To use a DataBarBorder class variable it first needs to be instantiated, for example

Dim dbb as DataBarBorder
Set dbb = ActiveCell.FormatConditions(1).BarBorder

Color

Returns an formatcolor that specifies the color of the border of data bars specified by a conditional formatting rule. Read-only.

Dim fcrColor As FormatColor
Set fcrColor = ActiveCell.FormatConditions(1).BarBorder.Color

Type

Returns or sets the type of border for data bars specified by a conditional formatting rule. Possible return values are xlDataBarBorderNone - The data bar has no border, xlDataBarBorderSolid - The data bar has a solid border.

ActiveCell.FormatConditions(1).BarBorder.Type = xlDataBarBorderNone