How to Add Cell Comment with Bold Text

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

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

Cheers Steve,

I will give it a try...

Thanks