Underlining a Value in a Variable Closed

Question

Hello Guys,

I have a variable which contains some value. I would like to underline it before printing it into a cell. I have used the following lines of code but does not work. Any help would be appreciated :)

Sub underline()
    
    Dim x As Variant
    x = "Hello"
    x.Font.underline = True
 
End Sub

Thanks :)

TrowaD · Answer

Hi AdiK,
You can't apply format to a variable, but you can to a cell.
Sub underline()
Dim x As Variant

x = "Hello"
Range("A1") = x
Range("A1").Font.underline = True

End Sub
Best regards,
Trowa

yg_be · Answer

I would rather try something such as :
Range("A3").Font.Underline = xlUnderlineStyleSingle
A good method to learn about that is to record a macro while manually changing the format of a cell : you will see in the recorded VBA code how to programmatically  access those attributes.

Underlining a Value in a Variable

2 responses

Similar discussions

Subscribe To Our Newsletter!