XlDataValidation Properties

Represents the data validation rule defined for a current worksheet.

Name	Description
AllowBlank	Gets or sets whether the data validation treats empty or blank entries as valid.
Criteria1	Gets or sets the value used in the criterion for data validation.
Criteria2	Gets or sets the value used in the criterion for data validation.
ErrorMessage	Gets or sets the error message to display when the entered data is not valid.
ErrorStyle	Gets or sets the style or the alert dialog window used to show the error message.
ErrorTitle	Gets or sets the caption of the error alert window.
ImeMode	Gets or sets the input method editor (IME) mode used by the data validation.
InputPrompt	Gets or sets the text for the input prompt message.
ListRange	Gets or sets the lists of cell ranges whose values should be used as the data validation criteria.
ListValues	Provides access to the list of values used in the data validation rule.
Operator	Gets or sets the relational operator used in the data validation rule.
PromptTitle	Gets or sets the title bar text of the prompt message.
Ranges	Provides access to the collection of cell ranges to which the data validation rule is applied.
ShowDropDown	Gets or sets whether to display the dropdown combo box for the XlDataValidationType.List validation rule.
ShowErrorMessage	Gets or sets whether to show the error message when the user input is not valid.
ShowInputMessage	Gets or sets whether to show the input message.
Type	Gets or sets the type of data validation.