Share via

Validation Object Members

  • Article
Excel Developer Reference

Represents data validation for a worksheet range.

Methods

  Name Description
Bb225747.methods(en-us,office.12).gif Add Adds data validation to the specified range.
Bb225747.methods(en-us,office.12).gif Delete Deletes the object.
Bb225747.methods(en-us,office.12).gif Modify Modifies data validation for a range.

Properties

  Name Description
Bb225747.properties(en-us,office.12).gif AlertStyle Returns the validation alert style. Read-only XlDVAlertStyle.
Bb225747.properties(en-us,office.12).gif 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.
Bb225747.properties(en-us,office.12).gif ErrorMessage Returns or sets the data validation error message. Read/write String.
Bb225747.properties(en-us,office.12).gif ErrorTitle Returns or sets the title of the data-validation error dialog box. Read/write String.
Bb225747.properties(en-us,office.12).gif 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.
Bb225747.properties(en-us,office.12).gif 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.
Bb225747.properties(en-us,office.12).gif IgnoreBlank True if blank values are permitted by the range data validation. Read/write Boolean.
Bb225747.properties(en-us,office.12).gif 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.
Bb225747.properties(en-us,office.12).gif InCellDropdown True if data validation displays a drop-down list that contains acceptable values. Read/write Boolean.
Bb225747.properties(en-us,office.12).gif InputMessage Returns or sets the data validation input message. Read/write String.
Bb225747.properties(en-us,office.12).gif InputTitle Returns or sets the title of the data-validation input dialog box. Read/write String.
Bb225747.properties(en-us,office.12).gif Operator Returns a Long value that represents the operator for the data validation.
Bb225747.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb225747.properties(en-us,office.12).gif ShowError True if the data validation error message will be displayed whenever the user enters invalid data. Read/write Boolean.
Bb225747.properties(en-us,office.12).gif 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.
Bb225747.properties(en-us,office.12).gif Type Returns a Long value, containing a XlDVType constant, that represents the data type validation for a range.
Bb225747.properties(en-us,office.12).gif Value Returns a Boolean value that indicates if all the validation criteria are met (that is, if the range contains valid data).