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
|