Tag Archives: Sample Code

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, Set Vertical Alignment (Sample Code)

In this article I will provide an example on how to set the vertical alignment of cells using VBA. The user selects the vertical alignment from a set of drop down lists. The selected vertical  alignment will be applied to the cell below the drop down list. You can download the file and code related to this article here. Upon

No Thumbnail

Excel VBA, Font Color

In this article I will explain how you can change the font color of cells and ranges in Excel using VBA. I’ve also provided an example on how you can get the current font color used in a cell. For more information about working with

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, Get Horizontal Alignment (Sample Code)

In this article I will provide an example on how to find cells with a specific horizontal alignment. You can download the code and file related to this article here. The user selects the desired horizontal alignment to find from a drop down list: After pressing

No Thumbnail

Excel VBA Print_UniqueTo_Column(), Sample Code + Download

In this article I will explain the function Print_UniqueTo_Column(). Print_UniqueTo_Column() is a function I’ve written in VBA for Excel. You can download the code and file related to this article here. Jump To: Input Parameters Example As Input it receives the location of a column of data and

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