Class CommentThreaded (Excel VBA)

The class CommentThreaded represents a cell's threaded comment. This object can represent both a top-level comment or its replies.

Class Range gives access to class CommentThreaded.

Member in collection


To use a CommentThreaded class variable it first needs to be instantiated, for example

Dim ctd as CommentThreaded
Set ctd = Dim strText As String: strText = 

The following procedures can be used to set variables of type CommentThreaded: CommentsThreaded.Item, AddReply, Next, Previous, Range.AddCommentThreaded and Range.CommentThreaded.

For Each

Here is an example of processing the CommentThreaded items in a collection.

Dim ctdReplie As CommentThreaded
For Each ctdReplie In Application.Replies
Next ctdReplie

CommentsThreaded.Item - Returns a single object from a collection.

AddReply - If the comment is a top-level comment, it will add a reply to its replies collection.

Delete - Deletes the specified threaded comment and all replies associated with that comment (if any exist).

Next - Returns a CommentThreaded object that represents the next threaded comment.

Previous - Returns a CommentThreaded object that represents the previous threaded comment.

Text - Sets threaded comment text.


CommentsThreaded.Count returns a Long value that represents the number of objects in the collection.

Author returns the Author object that represents the author of the specified CommentThreaded object.

Date returns a date String-Variant that represents the date and time that a threaded comment was added in local time. Read-only.

Replies if this comment is a parent, returns a CommentsThreaded collection of CommentThreaded objects that are children/replies of the specified comment (if any exist). The replies are sorted by time stamp.


Author - Represents the author of the CommentThreaded object.

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