Underline a specific part of a text string using VBA.

[PUGresources]

Hey all,

Currently I'm working on a question that i'd like to look like this:

What is the value of the underlined digit in 8512?

<tbody>
</tbody>

The digit i'd like to underline is in cell X6 and the text string is in cell C9 (the formula for which is ="What is the value of the underlined digit in "&Y6&"?")

I'd like to have VBA code that is dynamic and picks up that i want "5" underlined from cell X6 and does it in cell C9.

I've also got a range of data (so, i'd like this to be applied to all of the range too) the value I want underlined from X6:X45 and the questions in the range C9:C48.

I found this about underlining in a string and tried to have a go myself, but I've got no idea how to adapt this as my vba is really not good enough!

Can anyone help please?

 

[PUGresources]

Whoops forgot the link:
https://www.mrexcel.com/forum/excel...underline-only-portions-text-single-cell.html

 

[RoryA]

Welcome to the forum.

Please take a minute to read the forum rules, especially related to cross-posting, and then add the relevant links here to your post(s) in any other forum(s). Thanks.

 

[PUGresources]

Thanks,

Just to make everyone aware i've cross posted this here:
https://www.excelforum.com/excel-pr...-of-a-text-string-inc-formulas-using-vba.html

 

[Rick Rothstein]

Currently I'm working on a question that i'd like to look like this:

What is the value of the underlined digit in 8512?

<tbody>
</tbody>

The digit i'd like to underline is in cell X6 and the text string is in cell C9 (the formula for which is ="What is the value of the underlined digit in "&Y6&"?")

You cannot format any part of the output from a formula differently from the rest of the output from that formula, you can only do that with a constant value. To do what you want would require you to use event code to duplicate the functionality of your formula outputting its result as a constant value to the cell and then change the format for a part of that constant.

 

[PUGresources]

Thank you, how do I do that please?

 

[PUGresources]

Problem is solved thanks for everyone's help!