In VBA, in addition to the standard controls already listed, there are a number of additional controls.
These additional controls are independent objects that share the common properties and methods of all controls, while also having their own unique properties and methods.
Adding an additional control
Additional controls can be added to the Toolbox (a new form must be added to the project) as follows:
- Select the command Tools | Additional Controls.
- In the Additional Controls window that appears , check the box next to the control you want to add from the list of Available Controls.
- Click OK.
As a result, the icon for the selected additional control will appear in the Toolbox.
NOTE
When distributing an application that uses an additional control, you must include the corresponding OCX file. The name and location of the OCX file can be found in the Location field of the Additional Controls window.
Removing an additional control
An unnecessary control can be removed from the Toolbox in almost the same way it was added:
- Select the command Tools | Additional Controls.
- In the Additional Controls window that appears, uncheck the box next to the control you want to remove from the list of Available Controls.
- Click OK.