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

See Also

Reference

NamedRange Interface

Microsoft.Office.Tools.Excel Namespace