Skip to main content

XlDataValidation Members

Represents the data validation rule defined for a current worksheet.

Constructors

Name Description
XlDataValidation() Initializes a new instance of the XlDataValidation class with the default settings.

Properties

Name Description
AllowBlank Gets or sets whether the data validation treats empty or blank entries as valid.
Criteria1 Gets or sets the value used in the criterion for data validation.
Criteria2 Gets or sets the value used in the criterion for data validation.
ErrorMessage Gets or sets the error message to display when the entered data is not valid.
ErrorStyle Gets or sets the style or the alert dialog window used to show the error message.
ErrorTitle Gets or sets the caption of the error alert window.
ImeMode Gets or sets the input method editor (IME) mode used by the data validation.
InputPrompt Gets or sets the text for the input prompt message.
ListRange Gets or sets the lists of cell ranges whose values should be used as the data validation criteria.
ListValues Provides access to the list of values used in the data validation rule.
Operator Gets or sets the relational operator used in the data validation rule.
PromptTitle Gets or sets the title bar text of the prompt message.
Ranges Provides access to the collection of cell ranges to which the data validation rule is applied.
ShowDropDown Gets or sets whether to display the dropdown combo box for the XlDataValidationType.List validation rule.
ShowErrorMessage Gets or sets whether to show the error message when the user input is not valid.
ShowInputMessage Gets or sets whether to show the input message.
Type Gets or sets the type of data validation.

Methods

Name Description
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
GetHashCode() Serves as the default hash function. Inherited from Object.
GetType() Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
ToString() Returns a string that represents the current object. Inherited from Object.
See Also