Share via


Validation Members

Include Protected Members
Include Inherited Members

Represents data validation for a worksheet range.

The Validation type exposes the following members.

Properties

  Name Description
Public property AlertStyle Returns the validation alert style. Read-only XlDVAlertStyle.
Public property Application Returns an Application object that represents the Microsoft Excel application.
Public property Creator Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only XlCreator.
Public property ErrorMessage Returns or sets the data validation error message. Read/write String.
Public property ErrorTitle Returns or sets the title of the data-validation error dialog box. Read/write String.
Public property Formula1 Returns the value or expression associated with the conditional format or data validation. Can be a constant value, a string value, a cell reference, or a formula. Read-only String.
Public property Formula2 Returns the value or expression associated with the second part of a conditional format or data validation. Read-only String.
Public property IgnoreBlank True if blank values are permitted by the range data validation. Read/write Boolean.
Public property IMEMode Returns or sets the description of the Japanese input rules. Can be one of the XlIMEMode constants. Read/write Integer.
Public property InCellDropdown True if data validation displays a drop-down list that contains acceptable values. Read/write Boolean.
Public property InputMessage Returns or sets the data validation input message. Read/write String.
Public property InputTitle Returns or sets the title of the data-validation input dialog box. Read/write String.
Public property Operator Returns the operator for the conditional format or data validation. Read-only Integer.
Public property Parent Returns the parent object for the specified object. Read-only.
Public property ShowError True if the data validation error message will be displayed whenever the user enters invalid data. Read/write Boolean.
Public property ShowInput True if the data validation input message will be displayed whenever the user selects a cell in the data validation range. Read/write Boolean.
Public property Type Returns data type validation for a range. Read-only Integer that can be one of the constants of XlDVType.
Public property Value True if all the validation criteria are met (that is, if the range contains valid data). Read-only Boolean.

Top

Methods

  Name Description
Public method Add Adds data validation to the specified range.
Public method Delete Deletes the object.
Public method Modify Modifies data validation for a range.

Top

See Also

Reference

Validation Interface

Microsoft.Office.Interop.Excel Namespace