Add Method

Adds data validation to a range of cells using the specified options.

[Visual Basic]
Overridable Sub Add( _
   ByVal type As ValidationType, _
   ByVal alertStyle As ValidationAlertStyle, _
   ByVal validationOperator As ValidationOperator, _
   ByVal formula1 As String, _
   ByVal formula2 As String _
) 

[C#]
virtual void Add( 
   ValidationType type,
   ValidationAlertStyle alertStyle,
   ValidationOperator validationOperator,
   string formula1,
   string formula2
);

[C++]
virtual void Add( 
   ValidationType type,
   ValidationAlertStyle alertStyle,
   ValidationOperator validationOperator,
   string* formula1,
   string* formula2
) 

[C++/CLI]
virtual void Add( 
   ValidationType type,
   ValidationAlertStyle alertStyle,
   ValidationOperator validationOperator,
   String^ formula1,
   String^ formula2
) 

Parameters

type

Specifies the type of data validation to add.

alertStyle

Specifies the alert style to use for alert messages.

validationOperator

Specifies the data validation operator.

formula1

Specifies the first data validation value, formula or list.

formula2

Specifies the second data validation value for ValidationOperator.Between or ValidationOperator.NotBetween.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

IValidation Interface  | IValidation Members

See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.