.AddComment

[Joe User]

In VBA I set text to a cell and then add a comment. I then
add text to the comment. The result is the cell has the
comment with the text that is supposed to be. However the
cell itself now has the text that I put in the cell, not
the comment but it appends itself. Example the Cell was
set to have the text: test. but now it has:testtesttest

 

[Jake Marx]

Hi Joe User,

In VBA I set text to a cell and then add a comment. I then
add text to the comment. The result is the cell has the
comment with the text that is supposed to be. However the
cell itself now has the text that I put in the cell, not
the comment but it appends itself. Example the Cell was
set to have the text: test. but now it has:testtesttest

I'm not sure what your code looks like, but something like this should work:

With Sheet1.Range("A1")
.Value = "celltext"
.AddComment "commenttext"
End With

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]