CommentsThreaded object (Excel)

A collection of top-level CommentThreaded objects in a Worksheet, or a collection of replies in a single threaded comment.

Remarks

Each threaded comment is represented by a CommentThreaded object.

Example

Use the CommentsThreaded property of the Worksheet object to return the CommentsThreaded collection. The following example updates the text of all the threaded comments on worksheet one.

Set cmt = Worksheets(1).CommentsThreaded 
For Each c In cmt 
 c.Text "Updated Comment"
Next

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

Worksheets(1).Range("e5").AddCommentThreaded("This is a Threaded Comment")

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 "Updated Text"

Methods

• Item

Properties

• Application
• Count
• Creator
• Parent

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.