Validation Properties

Name

Returns

Description

AlertStyle

Long

Read-only. Returns how the user will be alerted if the range includes invalid data. Uses the XlDVAlertStyle constants

ErrorMessage

String

Set/Get the error message to show for data validation

ErrorTitle

String

Set/Get what the title is for the error data validation dialog box

Formulai

String

Read-only. Returns the value, cell reference, or formula used for data validation

Formula2

String

Read-only. Returns the second part of the value, cell reference, or formula used for data validation. The Operator property must be xlBetween or xlNotBetween

IgnoreBlank

Boolean

Set/Get whether a blank cell is always considered valid

IMEMode

Long

Set/Get how the Japanese input rules are described. Use the XllMEMode constants

InCellDropdown

Boolean

Set/Get whether a drop-down list of valid values is displayed in the parent range. Used when the Type property is xlValidateList

InputMessage

String

Set/Get the validation input message to prompt the user for valid data

InputTitle

String

Set/Get what the title is for the input data validation dialog box

Operator

Long

Read-only. Returns the operator describing how Formulai and Formula2 are used for validation. Uses the XlFormat-ConditionOperator constants

ShowError

Boolean

Set/Get whether the error message will be displayed when invalid data is entered in the parent range

ShowInput

Boolean

Set/Get whether the input message will be displayed when the user chooses one of the cells in the parent range

Type

Long

Read-only. Returns the data validation type for the range. The XlDVType constants can be used (for example, xlVali-dateDecimal, xlValidateTime)

Value

Boolean

Read-only. Returns if the validation is fulfilled for the range

Was this article helpful?

0 0

Post a comment