DataValidationCommand Constructor(Worksheet,Int32,Int32,Reference[],DataValidationType,DataValidationErrorStyle,DataValidationOperator,String,String,Boolean,Boolean,Boolean,String,String,Boolean,String,String,ImeMode,Boolean)

In This Topic

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal worksheet As Worksheet, _
   ByVal contextRow As Integer, _
   ByVal contextColumn As Integer, _
   ByVal rangeRefs() As Reference, _
   ByVal type As DataValidationType, _
   ByVal errorStyle As DataValidationErrorStyle, _
   ByVal operator As DataValidationOperator, _
   ByVal formula1 As String, _
   ByVal formula2 As String, _
   ByVal ignoreBlank As Boolean, _
   ByVal inCellDropdown As Boolean, _
   ByVal showMessage As Boolean, _
   ByVal promptTitle As String, _
   ByVal promptMessage As String, _
   ByVal showError As Boolean, _
   ByVal errorTitle As String, _
   ByVal errorMessage As String, _
   ByVal imeMode As ImeMode, _
   ByVal showInvalidCells As Boolean _
)

'Usage
 
Dim worksheet As Worksheet
Dim contextRow As Integer
Dim contextColumn As Integer
Dim rangeRefs() As Reference
Dim type As DataValidationType
Dim errorStyle As DataValidationErrorStyle
Dim operator As DataValidationOperator
Dim formula1 As String
Dim formula2 As String
Dim ignoreBlank As Boolean
Dim inCellDropdown As Boolean
Dim showMessage As Boolean
Dim promptTitle As String
Dim promptMessage As String
Dim showError As Boolean
Dim errorTitle As String
Dim errorMessage As String
Dim imeMode As ImeMode
Dim showInvalidCells As Boolean
 
Dim instance As New DataValidationCommand(worksheet, contextRow, contextColumn, rangeRefs, type, errorStyle, operator, formula1, formula2, ignoreBlank, inCellDropdown, showMessage, promptTitle, promptMessage, showError, errorTitle, errorMessage, imeMode, showInvalidCells)

public DataValidationCommand( 
   Worksheet worksheet,
   int contextRow,
   int contextColumn,
   Reference[] rangeRefs,
   DataValidationType type,
   DataValidationErrorStyle errorStyle,
   DataValidationOperator operator,
   string formula1,
   string formula2,
   bool ignoreBlank,
   bool inCellDropdown,
   bool showMessage,
   string promptTitle,
   string promptMessage,
   bool showError,
   string errorTitle,
   string errorMessage,
   ImeMode imeMode,
   bool showInvalidCells
)

Parameters

worksheet
contextRow
contextColumn
rangeRefs
type
errorStyle
operator
formula1
formula2
ignoreBlank
inCellDropdown
showMessage
promptTitle
promptMessage
showError
errorTitle
errorMessage
imeMode
showInvalidCells

Reference

DataValidationCommand Class
DataValidationCommand Members
Overload List

Product Support Forum | Print this page