...
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 value)
{signature}{signature: |
Signature | ||||||
---|---|---|---|---|---|---|
| }
| |||||
Public Function CreateDataValidation(ByVal allowedType As ValidationType, ByVal comparison As ComparisonType, ByVal value As String) As DataValidation
{signature}
{parameters}
{param:allowedType}The data type allowed in the cell.{param}
{param:comparison}The comparison used to validate the cell's value.{param}
{param:value}A formula representing the constraint for the data validation.{param}
{returns}A [DataValidation|DataValidation] object.{returns}
{example}{code:csharp|title=C#} |
Parameters |
---|
Param | ||||
---|---|---|---|---|
| ||||
The data type allowed in the cell. |
Param | ||||
---|---|---|---|---|
| ||||
The comparison used to validate the cell's value. |
Param | ||||
---|---|---|---|---|
| ||||
A formula representing the constraint for the data validation. |
Returns |
---|
A DataValidation object. |
Example | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|