Validation Properties

Style of the error.

Gets or sets the type of data that is allowed in the cell range associated with the data validation.

Returns number of begin update calls that have no corresponding end update. Read-only.

Gets or sets the comparison operator used in data validation.

Returns data type validation for a range

First formula's DateTime value.

Second formula's DateTime value.

Message of the error box.

Title of the error box.

Gets or sets the first formula associated with data validation.

Gets or sets the second formula associated with data validation.

Indicates whether empty cell is allowed.

Message of the input box.

Title of the input box.

Indicates whether position of the prompt box is fixed.

Indicates whether prompt box is visible.

Indicates whether formula contains list of values.

Indicates whether to suppress drop-down arrow.

Gets the parent object of the current data validation instance.

Horizontal position of the prompt box.

Vertical position of the prompt box.

Indicates whether to show error box.

Indicates whether to show prompt box.

Array of possible values (when values in list are entered manually)