Font

Syntax

[SET ]XLS.Font[.property] = value

Description

This object property refers to the standard Windows font object. Either the XLS.Font object can be set in whole, or individual properties can be altered.

The Font object is used for formatting selected ranges and is used while setting new values in single or adjecent cells using SelectRange and SetValue methods.

Parameter	Description
value	Object of type StdFont, or a value of a property of the font object. Valid properties are: Bold Charset Italic Name Size Strikethrough Underline Weight

See Also

SelectRange, SetValue

Example

Sub Main

Dim myFont As StdFont

If Not XLS.AppInit() Then Exit Sub

XLS.AppVisible = True

XLS.AddWorkBook

Set myFony = XLS.Font

Debug.Print myFont.Name

XLS.Font.Bold = True

XLS.CloseWorkBook

XLS.AppClose

End Sub