XlDVType Enumeration
Specifies the type of validation test to be performed in conjunction with values.
Version Information
Version Added: Excel
| 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. |