Validation Type Enumeration

Find below the list of Excel validation types as per XlDVType enumeration. A validation type is specified when adding a validation test to a cell or range. In most cases, and depending on the type of validation, additional parameters are required (Formula1, Formula2, and Operator).

Name	Value	Description
xlValidateCustom	7	Data is validated using an arbitrary formula.
xlValidateDate	4	Date values.
xlValidateDecimal	2	Numeric values.
xlValidateInputOnly	0	Validate only when user changes the value.
xlValidateList	3	Value must be present in a specified list.
xlValidateTextLength	6	Length of text.
xlValidateTime	5	Time values.
xlValidateWholeNumber	1	Whole numeric values.

 

Enumerations