xlDVType |
| Specifies the type of validation test to be performed in conjunction with values. |
| xlValidateCustom | Data is validated using an arbitrary formula (7) |
| xlValidateDate | Date values (4) |
| xlValidateDecimal | Numeric values (2) |
| xlValidateInputOnly | Validate only when user changes the value (0) |
| xlValidateList | Value must be present in a specified list (3) |
| xlValidateTextLength | Length of text (6) |
| xlValidateTime | Time values (5) |
| xlValidateWholeNumber | Whole numeric values (1) |
| xlValidateCustom |
| Data is validated using an arbitrary formula (7) |
| xlValidateDate |
| Date values (4) |
| xlValidateDecimal |
| Numeric values (2) |
| xlValidateInputOnly |
| Validate only when user changes the value (0) |
| xlValidateList |
| Value must be present in a specified list (3) |
| xlValidateTextLength |
| Length of text (6) |
| xlValidateTime |
| Time values (5) |
| xlValidateWholeNumber |
| Whole numeric values (1) |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top