Share via


NamedRange.Style Property

Gets or sets a Style that represents the style of the NamedRange control.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
Property Style As Object
Object Style { get; set; }

Property Value

Type: System.Object
A Style that represents the style of the NamedRange control.

Examples

The following code example creates a new custom style that displays text vertically and then sets a NamedRange to use this style.

This example is for a document-level customization.

Private Sub CreateStyle()
        Dim verticalStyle As Excel.Style = _
            Globals.ThisWorkbook.Styles.Add("Vertical Text")
        verticalStyle.Orientation = Excel.XlOrientation.xlVertical

        Dim namedRange1 As Microsoft.Office.Tools.Excel.NamedRange _
            = Me.Controls.AddNamedRange(Me.Range("A1"), _
            "namedRange1")
        namedRange1.Style = verticalStyle
        namedRange1.Value2 = "This text is vertical" 
    End Sub
private void CreateStyle()
{
    Excel.Style verticalStyle = Globals.ThisWorkbook.Styles.Add(
        "Vertical Text");
    verticalStyle.Orientation = Excel.XlOrientation.xlVertical;

    Microsoft.Office.Tools.Excel.NamedRange namedRange1 =
        this.Controls.AddNamedRange(this.Range["A1"],
        "namedRange1");
    namedRange1.Style = verticalStyle;
    namedRange1.Value2 = "This text is vertical";
}

.NET Framework Security

See Also

Reference

NamedRange Interface

Microsoft.Office.Tools.Excel Namespace