Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

Comment Object [Excel 2003 VBA Language Reference]

Office 2003
Worksheet
Comments
Comment
Shape

Represents a cell comment. The Comment object is a member of the Comments collection.

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").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").AddComment
    .Visible = False
    .Text "reviewed on " & Date
End With
		


Methods | Delete Method | Next Method | Previous Method | Text Method

Parent Objects | Worksheet

Child Objects | Shape


Show: