Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Gets a Comment that represents the comment associated with the cell in the upper left corner of the NamedRange control.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
ReadOnly Property Comment As Comment
Get
Comment Comment { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.Comment
A Comment that represents the comment associated with the cell in the upper left corner of the NamedRange control.
Examples
The following code example creates a NamedRange and adds a comment to the cell. It then displays a message box that causes the comment to become visible if the user clicks OK.
This example is for a document-level customization.
Private commentRange As Microsoft.Office.Tools.Excel.NamedRange
Private Sub AddCommentToRange()
commentRange = Me.Controls.AddNamedRange( _
Me.Range("C3"), "setColumnRowRange")
Me.commentRange.AddComment("This is a comment.")
Dim comment1 As Excel.Comment = Me.commentRange.Comment
comment1.Visible = False
If MessageBox.Show("Display comment?", "Comment Test", _
MessageBoxButtons.OKCancel) = DialogResult.OK Then
comment1.Visible = True
End If
End Sub
Microsoft.Office.Tools.Excel.NamedRange commentRange;
private void AddCommentToRange()
{
commentRange = this.Controls.AddNamedRange(
this.Range["C3", missing], "setColumnRowRange");
this.commentRange.AddComment("This is a comment.");
Excel.Comment comment1 = this.commentRange.Comment;
comment1.Visible = false;
if (MessageBox.Show("Display comment?", "Comment Test",
MessageBoxButtons.OKCancel) == DialogResult.OK)
{
comment1.Visible = true;
}
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.