AllowBlankCells

Gets or sets a value indicating whether the validation should be skipped for blank cells.

ErrorAction

Gets or sets the action to perform when the validation fails.

ErrorMessage

Gets or sets the error message.

ErrorTitle

Gets or sets the title of the error message.

First

Gets or sets the first value of the validation. This value is interpreted differently depending on the type of the validation.

InputMessage

Gets or sets the input message.

InputTitle

Gets or sets the title of the input message.

Operator

Gets or sets the comparison operator, for validation types that require an operator.

OriginColumn

Gets or sets the origin column of this validation. All relative references in expressions associated with this validation are calculated based on this value.

OriginRow

Gets or sets the origin row of this validation. All relative references in expressions associated with this validation are calculated based on this value.

Second

Gets or sets the second value of the validation. This value is interpreted differently depending on the type of the validation.

ShowDropdownList

Gets or sets a value indicating whether to display drop-down list when a cell in the validated range is selected and the validation type is set to List.

ShowError

Gets or sets a value indicating whether to display error messages when the validation fails.

ShowInputMessage

Gets or sets a value indicating whether to display information message when a cell in the validated range is selected.

SortListEntries

Gets or sets a value indicating whether to sort the entries in the drop-down list.

Type

Gets or sets the validation type.

Worksheet

Gets the worksheet this validation is associated with.