Shows or hides a tool in the toolbars, enables or disables a tool, and/or sets or clears the text of a TextBoxTool or the value of a ComboBoxTool.
Overload Name | Description |
---|---|
Clear | Clears the text of a TextBoxTool or the value of a ComboBoxTool. |
General | Shows or hides a tool in the toolbars, enables or disables a tool, and/or sets the text of a TextBoxTool or the value of a ComboBoxTool. |
Clears the text of a TextBoxTool or the value of a ComboBoxTool.
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> SheetName SheetNumber AllSheets
|
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> FALSE TRUE
|
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> FALSE TRUE
|
ToolKey | The key of the tool. |
Shows or hides a tool in the toolbars, enables or disables a tool, and/or sets the text of a TextBoxTool or the value of a ComboBoxTool.
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> SheetName SheetNumber AllSheets
|
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> FALSE TRUE
|
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> FALSE TRUE
|
ToolKey | The key of the tool. |
Caption (7.7) | The caption for the specified tool. |
ToolTipText (7.7) | The tool-tip to display when the mouse cursor hovers over the specified tool. |
ToolTipTitle (7.7) | The tool-tip-title to display when the mouse cursor hovers over the specified tool. |
Enabled |
Whether the tool is enabled.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
Visible |
Whether the tool is visible.
Specify one of the following values or an arbitrary value:
<blank> FALSE TRUE
|
TextBoxText | The new text for a TextBoxTool. To clear the text, use the Clear overload. |
ComboBoxValue | The new value for a ComboBoxTool. To clear the value, use the Clear overload. |
DisplayStyle (7.7) |
Specifies how the tool is displayed in the toolbar.
Specify one of the following values or an arbitrary value:
<blank> Default DefaultForToolType TextOnlyAlways TextOnlyInMenus ImageAndText ImageOnlyOnToolbars
|