Underlining a Value in a Variable

Closed

AdiK - Nov 23, 2016 at 05:32 AM
yg_be Posts 22698 Registration date Sunday June 8, 2008 Status Contributor Last seen April 18, 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 :)

Underlining a Value in a Variable
Parse error: syntax error, unexpected variable - Guide
My documents environment variable - Guide
64 bit variable in c - Guide
How to underline a letter in a password on iphone - Guide
A href no underline - Guide

2 responses

Answer 1 / 2

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

Answer 2 / 2

yg_be Posts 22698 Registration date Sunday June 8, 2008 Status Contributor Last seen April 18, 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.

Similar discussions

How to store cell value in a variable excel vba OR Increase Cell Value in Excel

Sharepoint link to Excel via a cell variable

Macro to insert row based on variable cell value (text)

Excel Macro - Set and autofill a range?

Find and replace underlined words for a blank.

Similar discussions

Subscribe To Our Newsletter!