Page History

{description}
{excerpt}Assigns a data validation rule to all cells in the Area. If the [DataValidation] object uses a local reference or area in a formula (i.e. "=A5:B7"), then the area will adjust those local references accordingly based on the area's location. The original {{DataValidation}} object will not be affected.{excerpt}
{signature:C#}
 public void SetDataValidation(DataValidation dataValidation)
{signature}{signature:vb.net}
Public Sub SetDataValidation(ByVal dataValidation As DataValidation)
{signature}
{parameters}
{param:dataValidation}A [DataValidation|DataValidation] object
        representing the data validation rule to assign to the Area.{param}
{example}{code:csharp|title=C#}
area.SetDataValidation(myDataValidation);{code}
{code:vb.net|title=vb.net}
area.SetDataValidation(myDataValidation){code}

{example}
{scrollbar}