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
Printable View
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