NamedRange.Validation 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 a Validation object that represents data validation for the NamedRange control.

public:
 property Microsoft::Office::Interop::Excel::Validation ^ Validation { Microsoft::Office::Interop::Excel::Validation ^ get(); };

public Microsoft.Office.Interop.Excel.Validation Validation { get; }

member this.Validation : Microsoft.Office.Interop.Excel.Validation

Public ReadOnly Property Validation As Validation

Property Value

Validation

A Validation object that represents data validation for the NamedRange control.

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

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

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.

Applies to

Compartilhar via