| Name | Description | |
|---|---|---|
 | AlertStyle | Gets the validation alert style. |
| ErrorMessage | Gets or sets the data validation error message. |
| ErrorTitle | Gets or sets the title of the data validation error dialog box. |
| Formula1 | Gets the value or expression associated with the conditional format or data validation. |
| Formula2 | Gets the value or expression associated with the second part of a conditional format or data validation. |
| IgnoreBlank | Gets a value indicating whether blank values are permitted by the range data validation. |
| ImeMode | Gets or sets the description of the Japanese input rules. |
| InCellDropdown | Gets or sets data validation displays a drop-down list that contains acceptable values. |
| InputMessage | Gets or sets the data validation input message. |
| InputTitle | Gets or sets the title of the data validation input dialog box. |
| Operator | Gets a value indicating the operator for the data validation. |
| ShowError | Gets or sets the data validation error message will be displayed whenever the user enters invalid data. |
| ShowInput | Gets or sets the data validation input message will be displayed whenever the user selects a cell in the data validation range. |
| Type | Gets a value indicating the data type validation for a range. |
| Value | Gets a System.Boolean value indicating whether all the validation criteria are met (that is, if the range contains valid data). |
The following tables list the members exposed by IValidation.
Public Properties
Public Methods
| Name | Description | |
|---|---|---|
 | Add | Adds data validation to a range of cells using the specified options. |
| Delete | Deletes data validation. |
| Modify | Modifies existing data validation for a range of cells using the specified options. |
See Also