![Collapse image](collapse_all.gif)
![Expand Image](expand_all.gif)
![](collapse_all.gif)
![](expand_all.gif)
![](dropdown.gif)
![](dropdownHover.gif)
![Copy image](copycode.gif)
![CopyHover image](copycodeHighlight.gif)
The ExcelDataValidation type exposes the following members.
Properties
Name | Description | |
---|---|---|
![]() | Address |
Address of data validation
|
![]() | AllowBlank |
True if blanks should be allowed
|
![]() | AllowsOperator |
True if the validation type allows operator to be set.
|
![]() | Error |
Error message box text
|
![]() | ErrorStyle |
Warning style
|
![]() | ErrorTitle |
Title of error message box
|
![]() | Operator |
Operator for comparison between the entered value and Formula/Formulas.
|
![]() | Prompt | |
![]() | PromptTitle | |
![]() | ShowErrorMessage |
True if error message should be shown
|
![]() | ShowInputMessage |
True if input message should be shown
|
![]() | ValidationType |
Validation type
|