Underline a number in a label on a userform?

[birdieman]

1. Is it possible to underline a number through code when writing it to a userform? Example: A calculation yields 2017, and I would like to put it (through code) in a label in a userform with a solid line underneath it, like 2017

2. Is it possible to hard code (like through the properties editor) a line under a number in a userform label?

thanks

 

[Norie]

If you mean underline all the text in a label.

1 Yes

2 Yes

 

[birdieman]

thanks Norie -- I think I will write a letter to Satya Nadella at Microsoft and request they alter Excel to accommodate my needs.

 

[Norie]

I'm confused and I might have also caused confusion.

When I originally read the post. I thought you wanted to underline just the number in the label text so replied No to both questions.

I reread the post and it appears you want to underline the entire text in the label, and the answer to both questions is Yes for that.

 

[birdieman]

Yes, I want to underline the entire text in the label -- the entire label will always be only one number -- it may be long, but only one number.

so, how do I do that -- both through code and whatever other way there is

thanks

 

[Jerry Sullivan]

The how to part...

1. Modify the Underline property using VBA

Label1.Font.Underline = True

2. In the Properties Window with the Label object selected: Click on the Font property > Click on the "..." button > In the Font dialog, check "Underline"

 

[birdieman]

thank you -- I have only looked at the Font property in the properties window about a million times, and totally missed it -- it's right there up front as well !!! thanks to you and Norie