NamedRange.Value Property

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

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

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets or sets the value of the NamedRange control.

public:
 property System::Object ^ Value { System::Object ^ get(); void set(System::Object ^ value); };

public object Value { get; set; }

member this.Value : obj with get, set

Public Property Value As Object

Property Value

Object

The value of the NamedRange control.

Examples

The following code example demonstrates how to set the Value property with and without the optional parameters.

This version is for a document-level customization.

private void SetValue()
{
    Microsoft.Office.Tools.Excel.NamedRange namedRange1 =
        this.Controls.AddNamedRange(this.Range["A1"],
        "namedRange1");
    namedRange1.Value = "Smith";

    Microsoft.Office.Tools.Excel.NamedRange namedRange2 =
        this.Controls.AddNamedRange(this.Range["A2"],
        "namedRange2");
    namedRange2.set_Value(Excel.XlRangeValueDataType.xlRangeValueDefault,
        "Jones");
}

Private Sub SetValue()
    Dim namedRange1 As Microsoft.Office.Tools.Excel.NamedRange _
        = Me.Controls.AddNamedRange(Me.Range("A1"), _
        "namedRange1")
    namedRange1.Value = "Smith"

    Dim namedRange2 As Microsoft.Office.Tools.Excel.NamedRange _
        = Me.Controls.AddNamedRange(Me.Range("A2"), _
        "namedRange2")
    namedRange2.set_Value(Excel.XlRangeValueDataType.xlRangeValueDefault, _
        "Jones")
End Sub

This version is for an application-level add-in.

Remarks

The Value property can be used with the following optional parameters. If you specify the optional parameters, you must use the set_Value and get_Value accessors in Visual Basic and C#.

Parameter	Description
`RangeValueDataType`	One of the XlRangeValueDataType values that specifies the data type of the range value. The default is xlRangeValueDefault.
`_arg1`	The value of the NamedRange control. This parameter is used only with the set_Value accessor.

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

Applies to