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. |
See Also