Validation Members

Include Protected Members
Include Inherited Members

Represents data validation for a worksheet range.

The Validation type exposes the following members.

Properties

	Name	Description
	AlertStyle	Returns the validation alert style. Read-only XlDVAlertStyle.
	Application	Returns an Application object that represents the Microsoft Excel application.
	Creator	Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only XlCreator.
	ErrorMessage	Returns or sets the data validation error message. Read/write String.
	ErrorTitle	Returns or sets the title of the data-validation error dialog box. Read/write String.
	Formula1	Returns the value or expression associated with the conditional format or data validation. Can be a constant value, a string value, a cell reference, or a formula. Read-only String.
	Formula2	Returns the value or expression associated with the second part of a conditional format or data validation. Read-only String.
	IgnoreBlank	True if blank values are permitted by the range data validation. Read/write Boolean.
	IMEMode	Returns or sets the description of the Japanese input rules. Can be one of the XlIMEMode constants. Read/write Integer.
	InCellDropdown	True if data validation displays a drop-down list that contains acceptable values. Read/write Boolean.
	InputMessage	Returns or sets the data validation input message. Read/write String.
	InputTitle	Returns or sets the title of the data-validation input dialog box. Read/write String.
	Operator	Returns the operator for the conditional format or data validation. Read-only Integer.
	Parent	Returns the parent object for the specified object. Read-only.
	ShowError	True if the data validation error message will be displayed whenever the user enters invalid data. Read/write Boolean.
	ShowInput	True if the data validation input message will be displayed whenever the user selects a cell in the data validation range. Read/write Boolean.
	Type	Returns data type validation for a range. Read-only Integer that can be one of the constants of XlDVType.
	Value	True if all the validation criteria are met (that is, if the range contains valid data). Read-only Boolean.

Top

Methods

	Name	Description
	Add	Adds data validation to the specified range.
	Delete	Deletes the object.
	Modify	Modifies data validation for a range.

Top

See Also

Reference

Validation Interface

Microsoft.Office.Interop.Excel Namespace