changing font color and weight in comment boxes

B

Beaux

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
 
F

Frank Kabel

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

--
Regards
Frank Kabel
Frankfurt, Germany

Beaux said:
I can manually add a comment box to a worksheet cell and manually
Click to expand...
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?
 
B

Beaux

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?
 
Top