![]() ![]() ![]() The value of this property can be set to one of the constants: Regular, Bold, Italic, Bold Italic. The following code sets the font style of range A1:A5 to Italic. The value of this property can be set to an integer value from 1 to 409. The following code sets the font size of cell A1 to 14. The value of this property can be set to one of the constants: xlUnderlineStyleNone, xlUnderlineStyleSingle, xlUnderlineStyleDouble, xlUnderlineStyleSingleAccounting, xlUnderlineStyleDoubleAccounting. Range("A1").Font.Underline = xlUnderlineStyleDouble The following code sets the font of cell A1 to xlUnderlineStyleDouble (double underline). The value of this property can be set to one of the standard colors: vbBlack, vbRed, vbGreen, vbYellow, vbBlue, vbMagenta, vbCyan, vbWhite or an integer value from 0 to 16,581,375. To assist you with specifying the colour of anything, the VBA is equipped with a function named RGB.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |