XlDVType XlDVType 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 xlValidateCustom xlValidateCustom 7

Data is validated using an arbitrary formula.

xlValidateDate xlValidateDate xlValidateDate 4

Date values.

xlValidateDecimal xlValidateDecimal xlValidateDecimal 2

Numeric values.

xlValidateInputOnly xlValidateInputOnly xlValidateInputOnly 0

Only validate when user changes the value.

xlValidateList xlValidateList xlValidateList 3

Value must be present in a specified list.

xlValidateTextLength xlValidateTextLength xlValidateTextLength 6

Length of text.

xlValidateTime xlValidateTime xlValidateTime 5

Time values.

xlValidateWholeNumber xlValidateWholeNumber xlValidateWholeNumber 1

Whole numeric values.

Applies to