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
The Accidental Blogging Millionaires

The Accidental Blogging Millionaires

Get Inspired By The Most Popular Bloggers Online! If You Want To Skyrocket Your Success With Business And Improve Your Overall Life You Need To Have A Look At The Accidental Blogging Millionaires! Business can be a fight, particularly when you’re trying to establish one online and like all fights, to succeed you must find the winning techniques and apply them.

Get My Free Ebook


Post a comment