| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Typing in a text box control | Excel Discussion (Misc queries) | |||
| Legnth of text in textbox control | Excel Discussion (Misc queries) | |||
| Variable control tip text | Excel Discussion (Misc queries) | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
