AddValidation Method

In This Topic

Syntax

Visual Basic
C#

'Declaration
 
Public Function AddValidation( _
   ByVal cellRanges() As CellRange, _
   ByVal type As DataValidationType, _
   ByVal operator As DataValidationOperator, _
   ByVal errorStyle As DataValidationErrorStyle, _
   ByVal formula1 As String, _
   Optional ByVal formula2 As String, _
   Optional ByVal ignoreBlank As Boolean, _
   Optional ByVal inCellDropdown As Boolean, _
   Optional ByVal showInput As Boolean, _
   Optional ByVal inputTitle As String, _
   Optional ByVal inputMessage As String, _
   Optional ByVal showError As Boolean, _
   Optional ByVal errorTitle As String, _
   Optional ByVal errorMessage As String _
) As DataValidation

'Usage
 
Dim instance As SheetView
Dim cellRanges() As CellRange
Dim type As DataValidationType
Dim operator As DataValidationOperator
Dim errorStyle As DataValidationErrorStyle
Dim formula1 As String
Dim formula2 As String
Dim ignoreBlank As Boolean
Dim inCellDropdown As Boolean
Dim showInput As Boolean
Dim inputTitle As String
Dim inputMessage As String
Dim showError As Boolean
Dim errorTitle As String
Dim errorMessage As String
Dim value As DataValidation
 
value = instance.AddValidation(cellRanges, type, operator, errorStyle, formula1, formula2, ignoreBlank, inCellDropdown, showInput, inputTitle, inputMessage, showError, errorTitle, errorMessage)

public DataValidation AddValidation( 
   CellRange[] cellRanges,
   DataValidationType type,
   DataValidationOperator operator,
   DataValidationErrorStyle errorStyle,
   string formula1,
   string formula2,
   bool ignoreBlank,
   bool inCellDropdown,
   bool showInput,
   string inputTitle,
   string inputMessage,
   bool showError,
   string errorTitle,
   string errorMessage
)

Parameters

cellRanges
type
operator
errorStyle
formula1
formula2
ignoreBlank
inCellDropdown
showInput
inputTitle
inputMessage
showError
errorTitle
errorMessage

Reference

SheetView Class
SheetView Members