Tag Archives: Font

No Thumbnail

Excel VBA, Font Strikethrough

In this article I will explain how you can use VBA to add strikethrough to the font of cells and ranges. I’ve also provided a sample code which checks if a cell has the strikethrough font or not. You can download the file and code

No Thumbnail

Excel VBA Set Underline (Sample Code + Download)

In this article I’ve provided an example on how you could use VBA to set underlines for cells and ranges. There are 4 different underline style the user can select from: Single Double Single Accounting Double Accounting For more information about the different underline types and their associate VBA code please

No Thumbnail

Excel VBA, Underline Font Style

This article explains the different types of underlines possible to apply to cells and ranges. It also provides the associated VBA code for adding the underline. For examples using these codes please see: Excel VBA Set Underline (Sample Code + Download) Excel VBA Get Underline

No Thumbnail

Excel VBA, Font Subscript

In this article I will explain how you can use VBA to change the font style in a cell or range to subscript. I’ve also provided a sample code which checks if the font in a cell is subscript or not. You can download the file and code

No Thumbnail

Excel VBA, Font Size

In this article I will explain how you can change the size of the font for a cell or range in Excel using VBA. I’ve also provided an example on how you can retrieve the size of the font used in a cell or range.

No Thumbnail

Excel VBA, Font Superscript

In this article I will explain how you can use VBA to change the font style in a cell or range to superscript. I’ve also provided a sample code which checks if the font in a cell is superscript or not. You can download the file and code

No Thumbnail

Excel VBA, Font Name

In this article I will explain how you can change the font (name) used in a cell or range. I’ve also provided a sample code which gets the current font (name) used in a cell or range. You can download the code and file used

No Thumbnail

Excel VBA, Italic Font

In this article I will explain how you can use VBA to change the italic font property of cells and ranges. I have also provided an example on how to check if a cells has the italic font property on or off. Jump To: Basics Example 1,

No Thumbnail

Excel VBA, Bold Font

In this article I will explain how you can use VBA to change the bold font property of cells and ranges. I have also provided an example on how to check if a cells has the bold font property on or off. Jump To: Basics