commen t object in xecel97

[meridian99]

Hi XLBO,
Is there a function to read data from a comment box that is attached to a excel97 cell ? I'd like to add comments to 1 or more cells, then read it from the specific cell & save to variables later on.

many thanks

----------------------------------------

Using the Comment Object

Use the Comment property to return a Comment object. The following example changes the text in the comment in cell E5.

Worksheets(1).Range("E5&quot.Comment.Text "reviewed on " & Date

Use Comments(index), where index is the comment number, to return a single comment from the Comments collection. The following example hides comment two on worksheet one.

Worksheets(1).Comments(2).Visible = False

Use the AddComment method to add a comment to a range. The following example adds a comment to cell E5 on worksheet one.

With Worksheets(1).Range("e5&quot.AddComment
.Visible = False
.Text "reviewed on " & Date
End With

 

[xlbo]

Answered from the original post Rgds
~Geoff~