Page History

Description

...

Wiki Markup
{description} {excerpt}Returns the cell's [DataValidation] object if one exists. Otherwise, returns 'null'.

...


{remarks}
{example}{code:csharp|title=C#}
DataValidation dv = cellA1.DataValidation;

{code}
{code:vb.net

|title=vb.net

}
Dim dv As DataValidation = cellA1.DataValidation

Signature
C#	C#	{excerpt} {signature:C#} public DataValidation DataValidation{ get; set; }
Signature
{signature}{signature:vb.net	vb.net	} Public Property DataValidation() As DataValidation
Remarks
When setting the dataValidation, if the value {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.
Example

Code Block
csharp	csharp
title	C#
Code Block
vb.net	title

...

{code}

{example}
{scrollbar}

Versions Compared