changing font color and weight in comment boxes

[Guest]

I can manually add a comment box to a worksheet cell and manually boldface some of the text and change font colors on some of the text in that comment. However,I have not found a way to do this programmatically. Even recording a macro to mimic this is to no avail - the manual formatting of the text does not show up in the macro. Can this be done in VBA
Thanks,Beaux

 

[Frank Kabel]

Hi
see: http://www.contextures.com/xlcomments03.html

--
Regards
Frank Kabel
Frankfurt, Germany

I can manually add a comment box to a worksheet cell and manually

boldface some of the text and change font colors on some of the text in
that comment. However,I have not found a way to do this
programmatically. Even recording a macro to mimic this is to no
avail - the manual formatting of the text does not show up in the
macro. Can this be done in VBA?

 

[Guest]

Thanks - that helps a great deal - at least I can alter the text "in total" with that. What I really would like to do is change one word within the text to red and bold, not all of the text. It works manually, but I haven't managed that in code. Any thoughts?