.
...
| 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 |
...
|
...
object |
...
will |
...
not |
...
be |
...
affected. |
...
| Signature | ||||
|---|---|---|---|---|
| ||||
public void SetDataValidation(DataValidation dataValidation)
{signature}{signature: |
| Signature | ||||||
|---|---|---|---|---|---|---|
| }
| |||||
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#} |
| Parameters |
|---|
| Param | ||||
|---|---|---|---|---|
| ||||
A DataValidation object representing the data validation rule to assign to the Range. |
| Example | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|