View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Anony Anony is offline
external usenet poster
 
Posts: 35
Default adding cell comment via VBA (bold font?)

To change the comment text to bold:
ActiveCell.Comment.Shape.TextFrame.Characters.Font .Bold = True


"Greg" wrote:

Hi,

Is there a way to make part of a cell comment bold (user name in particular)
when a comment is being added via VBA?

Thanks,
--
______
Regards,
Greg