Font Object [Excel 2003 VBA Language Reference]

Multiple objects

Contains the font attributes (font name, font size, color, and so on) for an object.

Using the Font Object

Use the Font property to return the Font object. The following example formats cells A1:C5 as bold.

Worksheets("Sheet1").Range("A1:C5").Font.Bold = True

If you don't want to format all the text in a cell or graphic the same way, use the Characters property to return a subset of the text.

Properties | Application Property | Background Property | Bold Property | Color Property | ColorIndex Property | Creator Property | FontStyle Property | Italic Property | Name Property | OutlineFont Property | Parent Property | Shadow Property | Size Property | Strikethrough Property | Subscript Property | Superscript Property | Underline Property

Parent Objects | AxisTitle Object | CellFormat Object | Characters Object | ChartArea Object | ChartTitle Object | DataLabel Object | DataLabels Collection | DataTable Object | DisplayUnitLabel Object | FormatCondition Object | Legend Object | LegendEntry Object | Phonetic Object | Phonetics Collection | Range Collection | Style Object | TickLabels Object

Child Objects