XlDVType XlDVType XlDVType Enum

Definition

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

public enum class XlDVType
public enum XlDVType
Public Enum XlDVType
Inheritance
XlDVTypeXlDVTypeXlDVType

Fields

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