Class CommentsThreaded (Excel VBA)

A collection of top-level CommentThreaded objects in a Worksheet, or a collection of replies in a single threaded comment. To use a CommentsThreaded class variable it first needs to be instantiated, for example

Dim ctd as CommentsThreaded
Set ctd = ActiveCell.AddCommentThreaded.Replies

Count

Returns a Long value that represents the number of objects in the collection.

Dim lngCount As Long
lngCount = ActiveCell.AddCommentThreaded.Replies.Count

Item

Returns a single object from a collection.

Item (Index)

Index: The index number for the object.

Dim ctdCommentsThreaded As CommentThreaded
Set ctdCommentsThreaded = ActiveCell.AddCommentThreaded.Replies(Index:=1)