Page History

Description

...

Wiki Markup

{description}
{excerpt}Assigns a data validation rule to all cells in the Range. If the [DataValidation] object uses a local reference or area in a formula (i.e. "=A5:B7"), then the range will adjust those local references accordingly based on the range's location. The original {{DataValidation}} object will not be affected.

...

Signature
C#	C#	{excerpt} {signature:C#} public void SetDataValidation(DataValidation dataValidation)
Signature
{signature}{signature:vb.net	vb.net	} Public Sub SetDataValidation(ByVal dataValidation As DataValidation)

Parameters

{signature}
{parameters}
{param:dataValidation}A [DataValidation|DataValidation] object representing the data validation rule to assign to the Range.{param}
{example}{code:csharp|title=C#}
rng.SetDataValidation(myDataValidation);

{code}
{code:vb.net

|title=vb.net

}
rng.SetDataValidation(myDataValidation){code}

{example}

Param
dataValidation	dataValidation
A DataValidation object representing the data validation rule to assign to the Range.
Example

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

Space Shortcuts

Page tree

Versions Compared

Old Version 2

New Version 3

Key