Sets the selected value(s) of the specified Selector.
| Overload Name | Description |
|---|---|
| Clear | Clear the selected value(s) of a specified selector. |
| General | Set the selected value(s) of a specified selector. |
Clear the selected value(s) of a specified selector.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| SelectorID | The ID of the Selector. |
| ResetControl |
For the selector treeview, controls whether the expansion of the nodes is restored to the initial state when the selection is cleared or before the selection is set. By default, the treeview is not reset.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
Set the selected value(s) of a specified selector.
| Argument | Description |
|---|---|
| SpecifySheetBy |
Select how to specify which worksheet to select while the method is being executed.
Specify one of the following values or an arbitrary value:
<blank>SheetNameSheetNumberAllSheets
|
| SheetSpec | Specify the sheet-name or sheet-number, depending on SpecifySheetBy. If SpecifySheetBy is AllSheets then SheetSpec can be left empty. |
| Address | The address of a range to select for the execution of the method. |
| CellByCell | Whether to execute the method on a cell-by-cell basis, or on the range specified by the address. |
| ReverseOrder | Whether to loop through the rows and columns from highest to lowest. Only applies when CellByCell is true. |
| MethodCondition |
If the result of method-condition expression resolves to FALSE, then the method is not executed.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| CellCondition |
If the result of the condition expression resolves to FALSE, then the current cell is skipped.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| SelectorID | The ID of the Selector. |
| Required |
Whether a selection is required for the view to be built.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| Value | The new value(s) of the selector. If the selector is configured for multiselect then multiple values can be strung together with the specified delimiter. |
| ValueDelimiter | The delimiter to use to separate multiple values. |
| Enabled |
Whether the selector is enabled.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| Visible |
Whether the selector is visible.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| ResetControl |
For the selector treeview, controls whether the expansion of the nodes is restored to the initial state when the selection is cleared or before the selection is set. By default, the treeview is not reset.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|
| BringSelectionIntoView |
For the selector treeview and listbox, controls whether the selected item (or first selected item) is within the viewable area of the control.
Specify one of the following values or an arbitrary value:
<blank>FALSETRUE
|