Validation Properties
This documentation is archived and is not being maintained.

Validation Properties 

  Name Description
AlertStyle Returns the validation alert style. Read-only XlDVAlertStyle.
Application Returns an Application object that represents the Microsoft Excel application.
Creator Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only XlCreator.
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. 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. Read/write Integer.
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 the operator for the conditional format or data validation. Read-only Integer.
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 data type validation for a range. Read-only Integer that can be one of the constants of XlDVType.
Value True if all the validation criteria are met (that is, if the range contains valid data). Read-only Boolean.
Show:
© 2016 Microsoft