Edit

Share via

CommentThreaded.Previous method (Excel)

  • Article

Returns a CommentThreaded object that represents the previous threaded comment.

Syntax

expression.Previous

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 previous comment. Using this method on the first comment on a sheet returns Null (not the last comment on the previous sheet).

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

Example

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

Worksheets(1).Range("E1").CommentThreaded.Previous.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.