Edit

Share via

XlDVType Enum

  • Reference

Definition

Namespace:
Microsoft.Office.Interop.Excel
Assembly:
Microsoft.Office.Interop.Excel.dll

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

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

Fields

Name Value Description
xlValidateInputOnly 0

Only validate when user changes the value.
xlValidateWholeNumber 1

Whole numeric values.
xlValidateDecimal 2

Numeric values.
xlValidateList 3

Value must be present in a specified list.
xlValidateDate 4

Date values.
xlValidateTime 5

Time values.
xlValidateTextLength 6

Length of text.
xlValidateCustom 7

Data is validated using an arbitrary formula.

Applies to