Validation Validation Validation Interface

Definition

Represents data validation for a worksheet range.

public interface class Validation
[System.Runtime.InteropServices.Guid("0002442F-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface Validation
Public Interface Validation
Attributes

Remarks

Use the Validation property to return the Validation object.

Use the Add(XlDVType, Object, Object, Object, Object) method to add data validation to a range and create a new Validation object.

Properties

AlertStyle AlertStyle AlertStyle

Returns the validation alert style. Read-only XlDVAlertStyle.

Application Application Application

Returns an Application object that represents the Microsoft Excel application.

Creator Creator 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 ErrorMessage ErrorMessage

Returns or sets the data validation error message. Read/write String.

ErrorTitle ErrorTitle ErrorTitle

Returns or sets the title of the data-validation error dialog box. Read/write String.

Formula1 Formula1 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 Formula2 Formula2

Returns the value or expression associated with the second part of a conditional format or data validation. Read-only String.

IgnoreBlank IgnoreBlank IgnoreBlank

True if blank values are permitted by the range data validation. Read/write Boolean.

IMEMode IMEMode IMEMode

Returns or sets the description of the Japanese input rules. Can be one of the XlIMEMode constants. Read/write Integer.

InCellDropdown InCellDropdown InCellDropdown

True if data validation displays a drop-down list that contains acceptable values. Read/write Boolean.

InputMessage InputMessage InputMessage

Returns or sets the data validation input message. Read/write String.

InputTitle InputTitle InputTitle

Returns or sets the title of the data-validation input dialog box. Read/write String.

Operator Operator Operator

Returns the operator for the conditional format or data validation. Read-only Integer.

Parent Parent Parent

Returns the parent object for the specified object. Read-only.

ShowError ShowError ShowError

True if the data validation error message will be displayed whenever the user enters invalid data. Read/write Boolean.

ShowInput ShowInput 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 Type Type

Returns data type validation for a range. Read-only Integer that can be one of the constants of XlDVType.

Value Value Value

True if all the validation criteria are met (that is, if the range contains valid data). Read-only Boolean.

Methods

Add(XlDVType, Object, Object, Object, Object) Add(XlDVType, Object, Object, Object, Object) Add(XlDVType, Object, Object, Object, Object)

Adds data validation to the specified range.

Delete() Delete() Delete()

Deletes the object.

Modify(Object, Object, Object, Object, Object) Modify(Object, Object, Object, Object, Object) Modify(Object, Object, Object, Object, Object)

Modifies data validation for a range.

Applies to