XlDataValidation Properties
Represents the data validation rule defined for a current worksheet.
Name | Description |
---|---|
Allow |
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. |
Error |
Gets or sets the error message to display when the entered data is not valid. |
Error |
Gets or sets the style or the alert dialog window used to show the error message. |
Error |
Gets or sets the caption of the error alert window. |
Ime |
Gets or sets the input method editor (IME) mode used by the data validation. |
Input |
Gets or sets the text for the input prompt message. |
List |
Gets or sets the lists of cell ranges whose values should be used as the data validation criteria. |
List |
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. |
Prompt |
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. |
Show |
Gets or sets whether to display the dropdown combo box for the Xl |
Show |
Gets or sets whether to show the error message when the user input is not valid. |
Show |
Gets or sets whether to show the input message. |
Type | Gets or sets the type of data validation. |
See Also