View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AJL AJL is offline
external usenet poster
 
Posts: 18
Default 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?