Changing font mid edit within a cell
<p>I would like to change the font size of a portion of the text within a cell.  For example in the cell I type John Smith in the default font size then run the macro and reduce the font so the following text is 10 point.</p>

<p>John Smith (12 point)- (run macro) ABC Company (10 point)</p>

<p>I can only get the macro to change the font of the entire cell and only before I start typing in the cell.</p>