NamedRange.PrefixCharacter Property
Gets the prefix character for the NamedRange control.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Syntax
'Declaration
ReadOnly Property PrefixCharacter As Object
Object PrefixCharacter { get; }
Property Value
Type: System.Object
The prefix character for the NamedRange control.
Remarks
If the value of the TransitionNavigKeys property is false, this prefix character is ' for a text label, or blank. If the value of the TransitionNavigKeys property is true, this character is ' for a left-justified label, " for a right-justified label, ^ for a centered label, \ for a repeated label, or blank.
Examples
The following code example uses the PrefixCharacter property to display the prefix character for a NamedRange.
This example is for a document-level customization.
Private prefixRange As Microsoft.Office.Tools.Excel.NamedRange
Private Sub DisplayPrefixCharacter()
prefixRange = Me.Controls.AddNamedRange( _
Me.Range("C1"), "prefixRange")
If CStr(Me.prefixRange.PrefixCharacter) = "" Then
MessageBox.Show("The prefix character is blank.")
Else
MessageBox.Show("The prefix character is: " & _
Me.prefixRange.PrefixCharacter)
End If
End Sub
Microsoft.Office.Tools.Excel.NamedRange prefixRange;
private void DisplayPrefixCharacter()
{
prefixRange = this.Controls.AddNamedRange(
this.Range["C1"], "prefixRange");
if ((string)this.prefixRange.PrefixCharacter == "")
{
MessageBox.Show("The prefix character is blank.");
}
else
{
MessageBox.Show("The prefix character is: " +
this.prefixRange.PrefixCharacter);
}
}
.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.