Validation Properties

The Validation type exposes the following members.

Properties
  NameDescription
Public propertyAlertStyle
Represents the validation alert style.
Public propertyAreas
Gets all CellArea which contain the data validation settings.
Public propertyErrorMessage
Represents the data validation error message.
Public propertyErrorTitle
Represents the title of the data-validation error dialog box.
Public propertyFormula1
Represents the value or expression associated with the data validation.
Public propertyFormula2
Represents the value or expression associated with the data validation.
Public propertyIgnoreBlank
Indicates whether blank values are permitted by the range data validation.
Public propertyInCellDropDown
Indicates whether data validation displays a drop-down list that contains acceptable values.
Public propertyInputMessage
Represents the data validation input message.
Public propertyInputTitle
Represents the title of the data-validation input dialog box.
Public propertyOperator
Represents the operator for the data validation.
Public propertyShowError
Indicates whether the data validation error message will be displayed whenever the user enters invalid data.
Public propertyShowInput
Indicates whether the data validation input message will be displayed whenever the user selects a cell in the data validation range.
Public propertyType
Represents the data validation type.
Public propertyValue1
Represents the first value associated with the data validation.
Public propertyValue2
Represents the second value associated with the data validation.
See Also