Font Properties

Name

Returns

Description

Background

xlBackground

Set/Get the type of background used behind the font text (xlBackgroundAutomatic,xlBack-groundOpaque, and xlBackgroundTransparent). Use the XlBackground constants. Valid only for text on charts

Bold

Variant

Set/Get whether the font is bold

Color

Variant

Set/Get the color of the font. Use the RGB function to create the color value

ColorIndex

Variant

Set/Get the color of the font. Use the XlColorIndex constants or an index value in the current color palette

FontStyle

Variant

Set/Get what style to apply to the font (for example, "Bold")

Italic

Variant

Set/Get whether the font is italic

Name

Variant

Set/Get the name of the font

Size

Variant

Set/Get the font size of the font

Name

Returns

Description

Strikethrough

Variant

Set/Get whether the font has a strikethrough effect

Subscript

Variant

Set/Get whether the font characters look like a subscript

Superscript

Variant

Set/Get whether the font characters look like a superscript

ThemeColor

Variant

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

ThemeFont

XlThemeFont

Set/Get the font in the applied font scheme associated with an object

TintAndShade

Variant

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

Underline

Variant

Set/Get whether the font is underlined

0 0

Post a comment