NamedRange..::.Validation Property

Gets a Validation object that represents data validation for the NamedRange control.

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

Syntax

ReadOnly Property Validation As Validation

Validation Validation { get; }

Property Value

Type: Microsoft.Office.Interop.Excel..::.Validation
A Validation object that represents data validation for the NamedRange control.

Remarks

You must use the Startup event handler of a worksheet to add validation to a named range. For more information about the Startup event handler, see Events in Office Projects.

Examples

The following code example uses the Validation property to verify that a string with at least three characters is entered into a NamedRange. The SetValidation method must be called from the Startup event handler.

This example is for a document-level customization.

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

        namedRange1.Validation.Add( _
            Excel.XlDVType.xlValidateTextLength, _
            Excel.XlDVAlertStyle.xlValidAlertStop, _
            Excel.XlFormatConditionOperator.xlGreater, 3, )

        namedRange1.Validation.InputMessage = "Enter a name."
        namedRange1.Validation.ErrorMessage = _
            "Please enter a name with 3 or more characters." 
    End Sub

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

    namedRange1.Validation.Add(
        Excel.XlDVType.xlValidateTextLength,
        Excel.XlDVAlertStyle.xlValidAlertStop,
        Excel.XlFormatConditionOperator.xlGreater, 3);

    namedRange1.Validation.InputMessage = "Enter a name.";
    namedRange1.Validation.ErrorMessage =
        "Please enter a name with 3 or more characters.";
}

.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.

See Also

Reference

NamedRange Interface

Microsoft.Office.Tools.Excel Namespace