ActionEventArgs.Range Property (2007 System)
Gets the range containing the text that has been recognized as a smart tag.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
Public ReadOnly Property Range As Range
'Usage
Dim instance As ActionEventArgs
Dim value As Range
value = instance.Range
public Range Range { get; }
public:
property Range^ Range {
Range^ get ();
}
public function get Range () : Range
Property Value
Type: Range
The range containing the text that has been recognized as a smart tag.
Examples
The following code example demonstrates a handler for the Click event. The event handler uses the Range property to display the address of the cell that contains the recognized smart tag term. This code example is part of a larger example provided for the Action class.
This example is for a document-level customization.
Private Sub DisplayAddress_Click(ByVal sender As Object, _
ByVal e As Microsoft.Office.Tools.Excel.ActionEventArgs) _
Handles DisplayAddress.Click
Dim smartTagAddress As String = e.Range.Address( _
ReferenceStyle:=Excel.XlReferenceStyle.xlA1)
MsgBox("The recognized text '" & e.Text & _
"' is at range " & smartTagAddress)
End Sub
void DisplayAddress_Click(object sender,
Microsoft.Office.Tools.Excel.ActionEventArgs e)
{
string smartTagAddress = e.Range.get_Address(missing,
missing, Excel.XlReferenceStyle.xlA1, missing, missing);
System.Windows.Forms.MessageBox.Show("The recognized text '" + e.Text +
"' is at range " + smartTagAddress);
}
.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.