'Declaration
 
Sub ExcelSetValidationData( _
   ByVal valSheet As Integer, _
   ByVal inputSheet As Integer, _
   ByVal inputRgn As ArrayList, _
   ByVal valItems() As String, _
   ByVal valRgnList As ArrayList, _
   ByVal isEditable As Boolean _
) 

'Usage
 
Dim instance As IExcelBiffRead
Dim valSheet As Integer
Dim inputSheet As Integer
Dim inputRgn As ArrayList
Dim valItems() As String
Dim valRgnList As ArrayList
Dim isEditable As Boolean
 
instance.ExcelSetValidationData(valSheet, inputSheet, inputRgn, valItems, valRgnList, isEditable)

void ExcelSetValidationData( 
   int valSheet,
   int inputSheet,
   ArrayList inputRgn,
   string[] valItems,
   ArrayList valRgnList,
   bool isEditable
)

Parameters

valSheet

Sheet that contains the validation list cell

inputSheet

Sheet that contains the input cell range

inputRgn

Input cell range

valItems

Validation data if data is direct, null otherwise

valRgnList

Validation cell range list

isEditable

Display and behavior flags for the validation combo

Reference

IExcelBiffRead Interface
IExcelBiffRead Members