Expand Minimize

XlDVType Enumeration (Excel)

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

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.

Show:
© 2014 Microsoft