AddComment Method
TOC
Collapse the table of content
Expand the table of content

Range.AddComment Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Adds a comment to the range.

expression .AddComment(Text)

expression A variable that represents a Range object.

Parameters

Name

Required/Optional

Data Type

Description

Text

Optional

Variant

The comment text.

Return Value

Comment

This example adds a comment to cell E5 on worksheet one.

Worksheets(1).Range("E5").AddComment "Current Sales"

Concepts

Other resources

Show:
© 2016 Microsoft