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 )
'DeclarationPublic 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
'UsageDim 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)
Parameters
- cellRanges
- type
- operator
- errorStyle
- formula1
- formula2
- ignoreBlank
- inCellDropdown
- showInput
- inputTitle
- inputMessage
- showError
- errorTitle
- errorMessage