Share via


XlDVType Enumeration

Specifies the type of validation test to be performed in conjunction with values.

Version Information
 Version Added:  Excel 2007

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.