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’ve provided an example on how you can get the current underline style used in a cell. When the user presses the Run button the program loops through the cells in row 1. In row 2 the type of underline used is printed. There
This article explains the different font formatting options applicable to cells and ranges using VBA. Each section provides a link to a more detailed explanation with VBA code samples. When you right click a cell and select Format Cells a dialog will open: The Font tab has all the possible formatting