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.