Also please visit my website www.software-solutions-online.
#How to make a thick underline in excel free#
If you need assistance with your code, or you are looking for a VBA programmer to hire feel free to contact me. Excel VBA, Format Cells and Ranges Using the Macro Recorder.
![how to make a thick underline in excel how to make a thick underline in excel](https://www.howtogeek.com/wp-content/uploads/2015/05/00_lead_image_automatic_horizontal_line.png)
#How to make a thick underline in excel code#
You can download the code and file related to this article here. The second part of the code checks which value was chosen from the drop down list in cell B2 and adjusts the border thickness of the bottom edge of the range C4:F4 accordingly: The first part of the code checks which value was chosen from the drop down list in cell A2 and adjusts the border style of the bottom edge of the range C4:F4 accordingly: For a thin underline, which does not exactly overlap the text, copy the text below. The event handler executes when the user selects a new value from the drop down lists: There is no obvious simple method to add a non-bold underline to bold text. The main function for this example is a worksheet_change event handler. Range("C4:F4").Borders(xlEdgeBottom).Weight = xlThick Range("C4:F4").Borders(xlEdgeBottom).Weight = xlMedium Range("C4:F4").Borders(xlEdgeBottom).Weight = xlThin Range("c4:F4").Borders(xlEdgeBottom).LineStyle = xlDouble Range("c4:F4").Borders(xlEdgeBottom).LineStyle = xlSlantDashDot Range("C4:F4").Borders(xlEdgeBottom).LineStyle = xlDashDotDot Range("C4:F4").Borders(xlEdgeBottom).LineStyle = xlDash Range("C4:F4").Borders(xlEdgeBottom).LineStyle = xlDot Range("C4:F4").Borders(xlEdgeBottom).LineStyle = xlContinuous Private Sub worksheet_change( ByVal target As Range) 'exectues when the user makes changes to the sheet Under Line, choose a color from the Color list and a line thickness from the Line list. Right-click the line you want to change and click Properties. The code used for this example can be seen below: You need to have a Gantt chart open to follow these steps. For more information about creating drop down lists in Excel please see Excel VBA Drop Down Lists. For example, you can set bold font for parent rows to make. The drop down list is created using data validation. Draw attention to certain elements of your sheet by setting various font and cell background formats. Upon selecting a new value from the drop down lists, the border on the bottom edge of the cells C4:F4 is updated: Copy the formatting, and then paint it onto the Guidelines subtitle, to make the subtitle a. Select the Employee Orientation heading, and apply bold formatting to the heading. Then apply the thick underline to the word departments. In this example the user selects the line style and line weight using drop down lists in cells A2 and B2. Apply a thick underline to the word in a way that also assigns the Thick underline format to the Underline button. Range("C11:E11").Borders(xlEdgeBottom).LineStyle = xlDouble Range("C9:E9").Borders(xlEdgeBottom).LineStyle = xlSlantDashDot Range("C7:E7").Borders(xlEdgeBottom).LineStyle = xlDash Range("C5:E5").Borders(xlEdgeBottom).LineStyle = xlDashDot
![how to make a thick underline in excel how to make a thick underline in excel](https://www.tutorviacomputer.com/images/excel/lesson04/underline-acct-05-excel.png)
Range("C3:E3").Borders(xlEdgeBottom).LineStyle = xlDot Range("C1:E1").Borders(xlEdgeBottom).LineStyle = xlContinuous The code above is equivalent to the code below: Range(Cells(i, 3), Cells(i, 5)).Borders(xlEdgeBottom).LineStyle _ The borders were created using the code below:
![how to make a thick underline in excel how to make a thick underline in excel](https://www.howtogeek.com/wp-content/uploads/2015/08/00_lead_image_overline_in_word.png)
Basically we’ve got 6 different border line styles: