Use of AddComment in VBA Excel 2007

Question

When trying to insert a comment in a cell, It works OK this way:

Range("A1").AddComment "Text"

But when trying to insert a comment with a cell's content, It does not Work:

Range("A1").AddComment Range("B1").value

Is there any way to include in a cell a comment the value of another cell?

Answer 1

Surely:
a = Worksheets("Sheet1").Cells(2, 1).Value
Range("A3").AddComment (Str(a))

Answer 2

You can try this way also.

Range("a2").AddComment Range("b1").Text

Answer 3

What does "It does not Work" mean exactly?

Do you get this error.

---------------------------
Microsoft Visual Basic
---------------------------
Run-time error '1004':

Application-defined or object-defined error
---------------------------
OK   Help  
---------------------------

If so it caused by trying to add a comment to a cell that already has a comment.

---

Cheers www.andypope.info

Answer 4

Hi, I'm getting this error using AddComment, I have excel 2007. Please advise what do. Thanks a lot.

Answer 5

For adding a comment:

Range("A1").AddComment ("test")

For changing the existing comment:

Range("A2").Comment.Text Text:="test"

Answer 6

Thanks for that. now is inserting the comments

I think i found why i'm getting this error:

Run-time error '1004':

Application-defined or object-defined error

When I'm trying to addcomment when the cell has a comment.

but when i use  rng.Addcomment.delete and rng.comment.delete to delete the comment i'm getting this error:

run-time error 91

object variable or with block variable not set

Please advise how to solve this.

this variables are defined in this way.

Dim rng As Range

Set rng = Worksheets("sheet1").Cells( i,j)

Answer 7

For deleting a comment, you may use

Range("A1").Comment.Delete 

or

Cells(i,j).Comment.Delete