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
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
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
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
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.
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
By formatting cells and ranges you can give your worksheets a better look. Formatting applies to the following: The number format: Numeric, Date, Scientific … Text Alignment: Horizontal, Vertical, Orientation … Text Control: Wrap Text, Shrink to fit, Merge Cells … Text Direction Font Type:
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
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,
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