Description |
---|
Excerpt |
---|
Creates a DataValidation object which can be set on a Range, Area, or Cell. |
Signature | ||||
---|---|---|---|---|
| ||||
public DataValidation CreateDataValidation(ValidationType allowedType, ComparisonType comparison, System.String minimumValue, System.String maximumValue) |
Signature | ||||
---|---|---|---|---|
| ||||
Public Function CreateDataValidation(ByVal allowedType As ValidationType, ByVal comparison As ComparisonType, ByVal minimumValue As String, ByVal maximumValue As String) As DataValidation |
Parameters |
---|
Param | ||||
---|---|---|---|---|
| ||||
The data type allowed in the cell. |
Param | ||||
---|---|---|---|---|
| ||||
The comparison used to validate the cell's value. |
Param | ||||
---|---|---|---|---|
| ||||
A formula representing the cell's maximum value. |
Param | ||||
---|---|---|---|---|
| ||||
A formula representing the cell's minimum value. |
Returns |
---|
A DataValidation object. |
Example | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|