Validation Members (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Represents data validation for a worksheet range.

Name

Description

Add

Adds data validation to the specified range.

Delete

Deletes the object.

Modify

Modifies data validation for a range.

Name

Description

AlertStyle

Returns the validation alert style. Read-only XlDVAlertStyle.

Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

ErrorMessage

Returns or sets the data validation error message. Read/write String.

ErrorTitle

Returns or sets the title of the data-validation error dialog box. Read/write String.

Formula1

Returns the value or expression associated with the conditional format or data validation. Can be a constant value, a string value, a cell reference, or a formula. Read-only String.

Formula2

Returns the value or expression associated with the second part of a conditional format or data validation. Used only when the data validation conditional format Operator property is xlBetween or xlNotBetween. Can be a constant value, a string value, a cell reference, or a formula. Read-only String.

IgnoreBlank

True if blank values are permitted by the range data validation. Read/write Boolean.

IMEMode

Returns or sets the description of the Japanese input rules. Can be one of the XlIMEMode constants listed in the following table. Read/write Long.

InCellDropdown

True if data validation displays a drop-down list that contains acceptable values. Read/write Boolean.

InputMessage

Returns or sets the data validation input message. Read/write String.

InputTitle

Returns or sets the title of the data-validation input dialog box. Read/write String.

Operator

Returns a Long value that represents the operator for the data validation.

Parent

Returns the parent object for the specified object. Read-only.

ShowError

True if the data validation error message will be displayed whenever the user enters invalid data. Read/write Boolean.

ShowInput

True if the data validation input message will be displayed whenever the user selects a cell in the data validation range. Read/write Boolean.

Type

Returns a Long value, containing a XlDVType constant, that represents the data type validation for a range.

Value

Returns a Boolean value that indicates if all the validation criteria are met (that is, if the range contains valid data).

Show: