Microsoft Office Tutorials and References
In Depth Information
The Comment Object: A Case Study
Unfortunately, the items listed in the dialog box aren’t always clear, so locating the correct help
topic may require some trial and error. The dialog box in the figure appears when you type
Comment and then press F1. In this case, although Comment is an object, it may behave like a
property. Clicking the first item displays the help topic for the Comment object; clicking the
second item displays the help topic for the Comment property.
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
can’t change it.
Table 7-1: Properties of a Comment Object
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 an integer that indicates the application in which the object
Returns the parent object for the comment. (It is always a Range
Returns a Shape object that represents the shape attached to the
Is True if the comment is visible.