...
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 |
...
|
...
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 Area.{param}
{example}{code:csharp|title=C#} |
Parameters |
---|
Param | ||||
---|---|---|---|---|
| ||||
A DataValidation object |
Example | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Scrollbar |
---|