DataValidation Properties
Provides access to a data validation rule defined for a worksheet range.
Name | Description |
---|---|
Allow |
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. |
Error |
Gets or sets the message displayed in the error dialog invoked when data validation fails. |
Error |
Gets or sets the style of the alert dialog window used for data validation. |
Error |
Gets or sets the caption of the error alert window. |
Ime |
Gets or sets the IME (input method editor) mode used by the data validation. |
Input |
Gets or sets the input message text. |
Input |
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. |
Show |
Gets or sets whether to display the dropdown combo box for a validation of the Data |
Show |
Gets or sets whether to display the error alert when the user input is not valid. |
Show |
Gets or sets whether to display the message prompting the user for data input. |
Validation |
Gets the type of data validation. |
See Also