The IExcelDataValidation type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
 | Address |
Address of data validation
|
| AllowBlank |
True if input message should be shown
|
| AllowsOperator |
True if the current validation type allows operator.
|
| Error |
Error message box text (see property ShowErrorMessage)
|
| ErrorStyle |
Controls how Excel will handle invalid values.
|
| ErrorTitle |
Title of error message box (see property ShowErrorMessage)
|
| Prompt |
Info message text (see property ShowErrorMessage)
|
| PromptTitle |
Title of info box if input message should be shown (see property ShowInputMessage)
|
| ShowErrorMessage |
True if error message should be shown.
|
| ShowInputMessage |
True if input message should be shown
|
| ValidationType |
Validation type
|
