Microsoft Office Tutorials and References
In Depth Information
The Comment Object: A Case Study
continued
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
Property
Read-Only
Description
Application
Yes
Returns an object that represents the application that created the
comment (that is, Excel).
Author
Yes
Returns the name of the person who created the comment.
Creator
Yes
Returns an integer that indicates the application in which the object
was created.
Parent
Yes
Returns the parent object for the comment. (It is always a Range
object.)
Shape
Yes
Returns a Shape object that represents the shape attached to the
comment.
Visible
No
Is True if the comment is visible.
 
Search JabSto ::




Custom Search