Skip to main content

CommentThreaded object

Table of contents
  1. Remarks
  2. Example

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"

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>