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. {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 Range.{param} {example}{code:csharp|title=C#} rng.SetDataValidation(myDataValidation);{code} {code:vb.net|title=vb.net} rng.SetDataValidation(myDataValidation){code} {example} |
Page History
Overview
Content Tools