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. |