How to Add Cell Comment with Bold Text

[Sforster]

Hi,

I am trying to add a comment to a cell in Excel. Adding a comment is no problem but I want to be able to resize the comment and change the text to bold text.

Any ideas ??

Thanks
Steve

[Steve North]

Thew following code should show you how to do it. Put some text (at least 10 characters) in the comments attached to the top left cell of a worksheet and run the code.

Cells(1, 1).Comment.Shape.Height = 100
Cells(1, 1).Comment.Shape.TextFrame.Characters(1, 10).Font.Bold = True

[Sforster]

Cheers Steve,

I will give it a try...

Thanks