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.

Signature

	C#
	C#

 public void SetDataValidation(DataValidation dataValidation)

Signature

	vb.net
	vb.net

Public Sub SetDataValidation(ByVal dataValidation As DataValidation)

Parameters

Param

	dataValidation
	dataValidation

A DataValidation object
representing the data validation rule to assign to the Area.

Example

Code Block

area.SetDataValidation(myDataValidation);

Code Block

area.SetDataValidation(myDataValidation)

Scrollbar

Versions Compared