Underlining a Value in a Variable

Closed
AdiK - Nov 23, 2016 at 05:32 AM
yg_be Posts 22694 Registration date Sunday June 8, 2008 Status Contributor Last seen April 17, 2024 - Nov 24, 2016 at 04:12 PM
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 :)

2 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Nov 24, 2016 at 11:36 AM
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

0
yg_be Posts 22694 Registration date Sunday June 8, 2008 Status Contributor Last seen April 17, 2024 5
Nov 24, 2016 at 04:12 PM
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.
0