Properties of a Comment object

The Comment object has six properties. Table 7-1 contains a list of these properties, along with a brief description of each. If a property is read-only, your VBA code can read the property but cannot change it.

Table 7-1 PROPERTIES OF A COMMENT OBJECT

Property Read-Only

Application Yes

Author

Creator

Parent

Shape Yes

Visible No

Description

Returns an object that represents the application that created the comment (that is, Excel).

Returns the name of the person who created the comment.

Returns a number that specifies the application that created the object. Not used in Excel for Windows (relevant only for Excel for Macintosh).

Returns the parent object for the comment. (It is always a Range object.)

Returns a Shape object that represents the shape attached to the comment.

Is True if the comment is visible.

0 0

Post a comment