This documentation is archived and is not being maintained.

XlDVType Enumeration 

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

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

Dim xlDVType1 As XlDVType = XlDVType.xlValidateCustom

public enum XlDVType
public enum XlDVType
public enum XlDVType

Member nameDescription
xlValidateCustomData is validated using an arbitrary formula.
xlValidateDateDate values.
xlValidateDecimalNumeric values.
xlValidateInputOnlyOnly validate when user changes the value.
xlValidateListValue must be present in a specified list.
xlValidateTextLengthLength of text.
xlValidateTimeTime values.
xlValidateWholeNumberWhole numeric values.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms