Name | Description | |
---|---|---|
AlertStyle | Gets or sets the validation alert style. This is a read-only ValidationAlertStyle. | |
ErrorMessage | Gets or sets the data validation error message (read or write). | |
ErrorTitle | Gets or sets the title of the data-validation error dialog box (read or write). | |
Formula1 | Gets or sets the value or expression associated with the conditional format or data validation. Can be a constant value, a string value, a cell reference, or a formula (read-only string). | |
Formula2 | Gets or sets the value or expression associated with the second part of a conditional format or data validation (read-only string). | |
IgnoreBlank | Gets or sets whether blank values are permitted by the data range validation (read or write). | |
IMEMode | Gets or sets the description of the Japanese input rules. | |
InCellDropdown | Gets or sets whether data validation displays a drop-down list that contains acceptable values. | |
InputMessage | Gets or sets the data validation input message (read or write string). | |
InputTitle | Gets or sets the title of the data-validation input dialog box (read or write string). | |
Operator | Gets or sets the operator for the conditional format or data validation (read-only). | |
ShowError | Gets or sets whether the data validation error message will be displayed whenever the user enters invalid data (read or write). | |
ShowInputMessage | Gets or sets whether the data validation input message is displayed whenever the user selects a cell in the data validation range (read or write). | |
Type | Gets or sets the data type validation for a range (read-only). | |
Value | Gets whether all the validation criteria are met (that is, if the range contains valid data). This property is read-only. |