CommentThreaded.Next method (Excel)

Returns a CommentThreaded object that represents the next threaded comment.

Syntax

expression.Next

expression An expression that returns a CommentThreaded object.

Return value

CommentThreaded

Remarks

If called on a top-level (parent) CommentThreaded object, it returns a top-level (parent) CommentThreaded object that represents the next comment. Using this method on the last comment on a sheet returns Null (not the next comment on the next sheet).

If called on a reply CommentThreaded object, it returns a reply CommentThreaded object that represents the next reply of a thread. This method works only on one thread. Using this method on the last reply of a thread returns Null (not the next top-level comment).

Example

This example navigates to the next top-level comment after the comment in range A1, and updates its text.

Worksheets(1).Range("A1").CommentThreaded.Next.Text "CurrentSales"

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.