Page History

{description}
{excerpt}Creates a [DataValidation] object which can be set on a [Range], [Area], or [Cell].{excerpt}
{signature:C#}
 public DataValidation CreateDataValidation(ValidationType allowedType, System.String formula)

{signature}{signature:vb.net

}
Public Function CreateDataValidation(ByVal allowedType As ValidationType, ByVal formula As String) As DataValidation

...

The data type allowed in the cell.

...

For 'Custom' allowed type: the formula used to validate the cell's data. For 'List' allowed type: the formula referencing a range in the worksheet.

{signature}
{parameters}
{param:allowedType}The data type allowed in the cell.{param}
{param:formula}For 'Custom' allowed type: the formula used to validate the cell's data.  For 'List' allowed type: the formula referencing a range in the worksheet.{param}
{returns}A [DataValidation|DataValidation] object.{returns}
{example}{code:csharp|title=C#}

          DataValidation dataValidation =
               wb.createDataValidation(
               DataValidation.ValidationType.List,
               "C10:C18");
        

{code}
{code:vb.net

|title=vb.net

}

          Dim dataValidation As DataValidation = _
               wb.createDataValidation( _
               DataValidation.ValidationType.List, _
               "C10:C18")
        {code}

{example}