Border Properties

Name

Returns

Description

Color

Variant

Set/Get the color for a border. Use the RGB function to set the color

ColorIndex

Variant

Set/Get the color for a border. 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 a border (for example, xlDash). Use the xlLineStyle constants to set the value

ThemeColor xlThemeColor Set/Get the theme color in the applied color scheme

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 Theme-Color 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

Weight

xlBorder Weight

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

0 0

Post a comment