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




"George Godik" wrote in message
...
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

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




"George Godik" wrote in message
...
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


.