Testing for Comments?

[ribhead]

I am trying to write in some code that will put in a comment filled with the date and time when a cell is changed. The problem is the cell can be changed numerous times so how can test for a comment with an If statement? If there is a comment I want to delete it and fill it with anohter comment. It would be nice to add to the original comment but that might be a little more than anyone wants to help me with. Any help would be great!!!

I may not be very smart but I'm sure wirey!!!!

 

[Zathras]

You can search here for many threads discussing ways to work with Excel cell comments. Here is one such: thread68-519901

 

[ribhead]

This is what I ended up doing. Thanks for the post however. I'm very new so a lot of this I have to keep simple.

Sub whatever()
On Error GoTo ErrorHandler
Range("A1&quot.AddComment "It"
GoTo Line10
ErrorHandler:
Range("A1&quot.Comment.Delete
Range("A1&quot.AddComment "works"
Line10:
End Sub

I may not be very smart but I'm sure wirey!!!!