Excel Comments

  • Thread starter Thread starter George Godik
  • Start date Start date
G

George Godik

I need some help with Excel comments. I am unable to find
useable documentation other than the function defenitions
in the MSDN for the cell comment object in excel.

more specifically, I need some part of text in the comment
field to be bold. I am able to find the text I need in the
text string, but I am unable to format it.

recording a macro does not help : it does not reflect text
format changes done to the comments

any help would be appreciated

- George
 
George,

Use code like the following:

Dim CMT As Comment
Set CMT = Range("A1").AddComment()
CMT.Text "this is a test"
CMT.Shape.TextFrame.Characters(11, 4).Font.Bold = True



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
thanks
-----Original Message-----
George,

Use code like the following:

Dim CMT As Comment
Set CMT = Range("A1").AddComment()
CMT.Text "this is a test"
CMT.Shape.TextFrame.Characters(11, 4).Font.Bold = True



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com







.
Click to expand...
 
Back
Top