XlDVType enumeration (Microsoft.Office.Interop.Excel)

XlDVType enumeration

Office 2013 and later

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

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

Syntax

No code example is currently available or this language may not be supported.

	Member name	Description
	xlValidateInputOnly	Only validate when user changes the value.
	xlValidateWholeNumber	Whole numeric values.
	xlValidateDecimal	Numeric values.
	xlValidateList	Value must be present in a specified list.
	xlValidateDate	Date values.
	xlValidateTime	Time values.
	xlValidateTextLength	Length of text.
	xlValidateCustom	Data is validated using an arbitrary formula.