XlDVType enumeration (Excel)
Specifies the type of validation test to be performed in conjunction with values.
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. |
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.