DataValidation Properties

Provides access to a data validation rule defined for a worksheet range.

Name	Description
AllowBlank	Gets or sets whether the data validation treats empty or blank entries as valid.
Criteria	Gets or sets the value used in the criterion for the data validation.
Criteria2	Gets or sets the value used in the criterion for the data validation.
ErrorMessage	Gets or sets the message displayed in the error dialog invoked when data validation fails.
ErrorStyle	Gets or sets the style of the alert dialog window used for data validation.
ErrorTitle	Gets or sets the caption of the error alert window.
ImeMode	Gets or sets the IME (input method editor) mode used by the data validation.
InputMessage	Gets or sets the input message text.
InputTitle	Gets or sets the title bar text of the input prompt dialog window.
Operator	Gets or sets the relational operator used in the data validation rule.
Range	Gets or sets the worksheet range to which the data validation rule is applied.
ShowDropDown	Gets or sets whether to display the dropdown combo box for a validation of the DataValidationType.List type.
ShowErrorMessage	Gets or sets whether to display the error alert when the user input is not valid.
ShowInputMessage	Gets or sets whether to display the message prompting the user for data input.
ValidationType	Gets the type of data validation.