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

how about only part of the comment?

for instant:
John Smith:
this cell has a comment


--
______
Regards,
Greg


"Anony" wrote:

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