XLS Object

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