Bolding text in a control text box.
 

Hello,

I have a control text box, with a large amount of text that is being copied
and pasted in via a macro button. Several different paragraphs are pasted
depending on the results of several Vlookups. I would like to know, is there
a way for me to highlight and bold the first sentence of each paragraph in a
control text box? Setting the font to bold in properties bolds everything,
and i cannot use a shape text box as it has a 255 character string limit.
Any thoughts?

Bolding text in a control text box.
 

Select the text in the first sentence, then click the B toolbar button (or
press ctrl/B)

"AJL" wrote:

Hello,

I have a control text box, with a large amount of text that is being copied
and pasted in via a macro button. Several different paragraphs are pasted
depending on the results of several Vlookups. I would like to know, is there
a way for me to highlight and bold the first sentence of each paragraph in a
control text box? Setting the font to bold in properties bolds everything,
and i cannot use a shape text box as it has a 255 character string limit.
Any thoughts?

Bolding text in a control text box.
 

Hi Bob,

Textboxes from the Control toolbar do not support multi font formats.

Your suggestion will work on a textbox from the Drawing toolbar though.

Cheers
Andy

Bob Umlas wrote:
Select the text in the first sentence, then click the B toolbar button (or
press ctrl/B)

"AJL" wrote:


Hello,

I have a control text box, with a large amount of text that is being copied
and pasted in via a macro button. Several different paragraphs are pasted
depending on the results of several Vlookups. I would like to know, is there
a way for me to highlight and bold the first sentence of each paragraph in a
control text box? Setting the font to bold in properties bolds everything,
and i cannot use a shape text box as it has a 255 character string limit.
Any thoughts?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Bolding text in a control text box.
 

Okay, thanks for the help!

-Alan Lueke

"Andy Pope" wrote:

Hi Bob,

Textboxes from the Control toolbar do not support multi font formats.

Your suggestion will work on a textbox from the Drawing toolbar though.

Cheers
Andy

Bob Umlas wrote:
Select the text in the first sentence, then click the B toolbar button (or
press ctrl/B)

"AJL" wrote:


Hello,

I have a control text box, with a large amount of text that is being copied
and pasted in via a macro button. Several different paragraphs are pasted
depending on the results of several Vlookups. I would like to know, is there
a way for me to highlight and bold the first sentence of each paragraph in a
control text box? Setting the font to bold in properties bolds everything,
and i cannot use a shape text box as it has a 255 character string limit.
Any thoughts?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info