xlDVType

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

xlValidateCustomData is validated using an arbitrary formula (7)
xlValidateDateDate values (4)
xlValidateDecimalNumeric values (2)
xlValidateInputOnlyValidate only when user changes the value (0)
xlValidateListValue must be present in a specified list (3)
xlValidateTextLengthLength of text (6)
xlValidateTimeTime values (5)
xlValidateWholeNumberWhole 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)


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top