SpreadsheetGear 2023
IValidation Interface

SpreadsheetGear Namespace : IValidation Interface
Represents the data validation associated with a range of cells.
Object Model
IValidation Interface
Public Interface IValidation 
Dim instance As IValidation
public interface IValidation 

With the exception of IValidation.Value and IValidation.Delete, data validation properties and methods cannot be used unless all of the represented cells currently have the same data validation criteria.

Use IValidation.Value to determine whether the represented cells meet their data validation criteria.

Use IValidation.Add to add data validation to cells which currently have no data validation.

Use IValidation.Modify to modify data validation settings of cells which already have data validation.

Use IValidation.Delete to delete all data validation criteria currently associated with the represented cells.

Use IValidation.InputMessage and IValidation.InputTitle to get and set the input message to be displayed when one of the represented cells is active.

Use IValidation.ErrorMessage and IValidation.ErrorTitle to get and set the error message to be displayed when data validation fails.


Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also


IValidation Members
SpreadsheetGear Namespace