
The value of this property can be set to one of the fonts: Calibri, Times new Roman, Arial. The following code sets the font name of range A1:A5 to Calibri. The value of this property can be set to one of the constants: Regular, Bold, Italic, Bold Italic. You can also type in any size you want, within the following. On the Home tab, click the font size in the Font Size box. To select all text in a Word document, press Ctrl + A. Navigate to the Home tab and click on the Font Size box. Just follow these steps: Select the cell range you want to change the font size for. It's quite easy to change the font size in Excel. The following code sets the font style of range A1:A5 to Italic. To change the font size of selected text in desktop Excel, PowerPoint, or Word: Select the text or cells with text you want to change. However, you can change this size by adjusting the cell font size to any size between 1 and 409 points.

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). Report Differences Between TM1 Executive Viewer and IBM Cognos Analytics with. 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.
