CommentThreaded object (Excel)

Represents a cell's threaded comment. This object can represent both a top-level comment or its replies.

Remarks

The CommentThreaded object is a member of the CommentsThreaded collection.

Example

Use the CommentThreaded property of the Range object to return a CommentThreaded object. The following example changes the text in the threaded comment in cell E5.

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

Use CommentsThreaded (index), where index is the threaded comment number, to return a single threaded comment from the CommentsThreaded collection. The following example updates the text of threaded comment two on worksheet one.

Worksheets(1).CommentsThreaded(2).Text "reviewed on " & Date

Use the AddCommentThreaded method of the Range object to add a comment to a range. The following example adds a threaded comment to cell E5 on worksheet one.

Worksheets(1).Range("E5").AddCommentThreaded "Current Sales"

Methods

• AddReply
• Delete
• Next
• Previous
• Text

Properties

• Application
• Author
• Creator
• Date
• Parent
• Replies

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.