XlDVType Enumeration
TOC
Collapse the table of content
Expand the table of content

XlDVType Enumeration

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

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlValidateCustom7Data is validated using an arbitrary formula.
xlValidateDate4Date values.
xlValidateDecimal2Numeric values.
xlValidateInputOnly0Validate only when user changes the value.
xlValidateList3Value must be present in a specified list.
xlValidateTextLength6Length of text.
xlValidateTime5Time values.
xlValidateWholeNumber1Whole numeric values.


Show:
© 2016 Microsoft