Click or drag to resize

XlsValidation Properties

The XlsValidation type exposes the following members.

Properties
Name Description
Public property AlertStyle
Style of the error.
Public property AllowType
Type of the allowed data.
Public property CompareOperator
Compare operator used.
Public property DataRange
Range of possible values.
Public property DateTime1
First formula's DateTime value.
Public property DateTime2
Second formula's DateTime value.
Public property ErrorMessage
Text of the error message.
Public property ErrorTitle
Title of the error box.
Public property Formula1
Value of the first formula.
Public property Formula2
Value of the second formula.
Public property IgnoreBlank
Indicates whether empty cell is allowed.
Public property InputMessage
Text of the prompt box.
Public property InputTitle
Title of the prompt box.
Public property IsInputPositionFixed
Indicates whether position of the prompt box is fixed.
Public property IsInputVisible
Indicates whether prompt box is visible.
Public property IsListInFormula
Indicates whether formula contains list of values.
Public property IsSuppressDropDownArrow
Indicates whether to suppress drop-down arrow.
Public property Parent
Parent object for this object.
Public property ParentCollection
Gets / sets parent data validation collection.
Public property PromptBoxHPosition
Horizontal position of the prompt box.
Public property PromptBoxVPosition
Vertical position of the prompt box.
Public property ShapesCount
Gets number of required shapes objects.
Public property ShowError
Indicates whether to show error box.
Public property ShowInput
Indicates whether to show prompt box.
Public property Values
If this is data validation list, then gets / sets array of all possible values.
Public property Worksheet
Parent worksheet.
Top
See Also