XlDVType Enum


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

public enum class XlDVType
public enum XlDVType
Public Enum XlDVType


xlValidateCustom 7

Data is validated using an arbitrary formula.

xlValidateDate 4

Date values.

xlValidateDecimal 2

Numeric values.

xlValidateInputOnly 0

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

Applies to