IDataValidation Properties |
The IDataValidation type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
|
AlertStyle |
Style of the error.
|
|
|
AllowType |
Type of the allowed data.
|
|
|
CompareOperator |
Compare operator used.
|
|
|
DataRange |
Range of possible values.
|
|
|
DateTime1 |
First formula's DateTime value.
|
|
|
DateTime2 |
Second formula's DateTime value.
|
|
|
ErrorMessage |
Text of the error message.
|
|
|
ErrorTitle |
Title of the error box.
|
|
|
Formula1 |
Value of the first formula.
|
|
|
Formula2 |
Value of the second formula.
|
|
|
IgnoreBlank |
Indicates whether empty cell is allowed.
|
|
|
InputMessage |
Text of the prompt box.
|
|
|
InputTitle |
Title of the prompt box.
|
|
|
IsInputPositionFixed |
Indicates whether position of the prompt box is fixed.
|
|
|
IsInputVisible |
Indicates whether prompt box is visible.
|
|
|
IsListInFormula |
Indicates whether formula contains list of values.
|
|
|
IsSuppressDropDownArrow |
Indicates whether to suppress drop-down arrow.
|
|
|
Parent |
Gets the parent object of the current instance.
(Inherited from
IExcelApplication
.)
|
|
|
PromptBoxHPosition |
Horizontal position of the prompt box.
|
|
|
PromptBoxVPosition |
Vertical position of the prompt box.
|
|
|
ShowError |
Indicates whether to show error box.
|
|
|
ShowInput |
Indicates whether to show prompt box.
|
|
|
Values |
Array of possible values (when values in list are entered manually)
|
See Also
