Skip to main content
Row

DataValidation Members

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

Properties

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