CommentThreaded object (Excel)
Represents a cell's threaded comment. This object can represent both a top-level comment or its replies.
The CommentThreaded object is a member of the CommentsThreaded collection.
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"
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.