...
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 | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|