Share via

NamedRange.Style Property

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel
Assembly:
Microsoft.Office.Tools.Excel.dll

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

public:
 property System::Object ^ Style { System::Object ^ get(); void set(System::Object ^ value); };
public object Style { get; set; }
member this.Style : obj with get, set
Public Property Style As Object

Property Value

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 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";
}

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

Applies to