Page History

{description}
{excerpt}Returns the cell's [DataValidation] object if one exists.  Otherwise, returns 'null'.
{excerpt}
{signature:C#}
 public DataValidation DataValidation{ get; set; }
{signature}{signature:vb.net}
Public Property DataValidation() As DataValidation
{signature}
{remarks}
When setting the dataValidation, if the value you're setting it to uses a local reference or area in a formula (i.e. "=A5:B7"), then the cell will adjust those local references accordingly based on the cell's location. The original dataValidation object you assigned the cell to use will remain unaffected.
{remarks}
{example}{code:csharp|title=C#}
DataValidation dv = cellA1.DataValidation;{code}
{code:vb.net|title=vb.net}
Dim dv As DataValidation = cellA1.DataValidation{code}

{example}
{scrollbar}