Borders Collection Properties

The Borders collection has a few properties besides the typical collection attributes. They are listed in the following table.

Name

Returns

Description

Color

Variant

Set/Get the color for all four of the borders in the collection. Use the RGB function to set the color

ColorIndex

Variant

Set/Get the color for all four of the borders in the collection. Use the index number of a color in the current color palette to set the Color value

LineStyle

xlLineStyle

Set/Get the style of line to use for the borders (for example, xlDash). Use the xlLineStyle constants to set the value

ThemeColor

xlThemeColor

Set/Get the theme color in the applied color scheme associated with an object. Should the object have no association with a theme, then trying to access the ThemeColor property will result in an error

TintAndShade

Single

Set/Get a Single value from -1 (darkest) to 1 (lightest), which darkens or lightens a color. Zero (0) is neutral

Value

xlLineStyle

Set/Get the style of line to use for the borders (for example, xlDash). Use the xlLineStyle constants to set the value. Same as LineStyle

Weight Weight

xlBorder

Set/Get how thick to make the borders in the collection (for example, xlThin, xlThick). Use the xlBorderWeight constants

0 0

Post a comment