Changing font on certain words in a cell.

[CEC]

Hi experts,

Using Excel (VBA). I have a variable(and/or) a cell.value containing text (normally 1 or 2 paragraphs). I would like to make certain words (the titles - see below) in bold but not all the text in the variable or cell.value. I've considered using a .find and then playing with the .character option but I was hoping there would be a better/easier way. Perhaps an existing function that I might not be aware of.

i.e. Variable or Cell.Value would contain the following end result: (I can achieve these results already - without the bold title option)
--------------------------------------------------------------------------------------------

Entered by: John Doe
--------------------------
PA Period
From: 5/18/2011
To : 5/18/2011
--------------------------
RI Criterias:
None

DNME Criterias:
None
--------------------------
Notes:
Bla bla bla here.

--------------------------------------------------------------------------------------------

Any ideas?

Edited: Added code below for a better idea. I'm manipulating data by "Add Entry" button on a form (IOEXForm) and items are populated by items in the form. The code below can provide the results above. Though I'm looking to put some of the text(titles) in bold. Any help would be appreciated.

Please Login or Register  to view this content.

[Leith Ross]

Hello CEC,

You should post your workbook. Seeing the layout, formatting, formulae, and any VBA code, will guarantee you get a working solution. A lot of time will also be saved by eliminating guesswork.