How to remove double underline in word update#

Excel VBA Get Underline (Sample Code + Download).

The IfР’В statement below checks if the user selected the Double Accounting underline style from the drop down list: The IfР’В statement below checks if the user selected the Single Accounting underline style from the drop down list: The IfР’В statement below checks if the user selected the DoubleР’В underline style from the drop down list: The IfР’В statement below checks if the user selected the Single underline style from the drop down list: The If statement below checks if the user selected РІР‚СљNoneРІР‚Сњ from the drop down list: The event handler loops through the columns and makes theР’В necessaryР’В changes: Range(Cells(2, i), Cells(2, i)).Font.Underline _Р”В®lseIf Cells(1, i) = 'Single Accounting' ThenР”В®lseIf Cells(1, i) = 'Double Accounting' Then Private Sub worksheet_change( ByVal target As Range) 'executes when the user selects a new value from the drop down lists The event handler executes when the user selects a new value from the drop down lists: The program uses a Worksheet_Change event handler. The data for the drop down lists are stored in sheet 2:

For more information about creating drop down lists in excel please see Excel VBA Drop Down Lists. The drop down lists are created using data validation.

How to remove double underline in word update#

In the figure below the user is selecting an underline style for cell C2 from the drop down list in cell C1:Р”Р„fter making the selection the underline style is update in the cell below: When the user makes a selection the underline style will change in row 2: The user selects an underline style from the drop down lists in row 1. You can download the file and code related to this article here. There are 4 different underline style the user can select from:Р”Р‡or more information about the differentР’В underlineР’В types and theirР’В associateР’В VBA code please see Excel VBA, Underline Font Style. In this article IРІР‚в„ўve provided an example on how you could use VBA to set underlines forР’В cellsР’В and ranges.