View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default changing font color and weight in comment boxes

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Beaux" schrieb im Newsbeitrag
...
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