How to Display the ActiveX Controls Toolbox in WPS VBA
Question details
The user needs to restore or access the ActiveX Controls toolbox in the VBA UserForm editor because only the standard toolbox is visible.

- Product
- WPS Spreadsheets (VBA editor)
- Device & OS
- not provided
- Scenario
- Working in the VBA UserForm editor to add ActiveX controls to a UserForm.
- Observed behavior
- Only the standard Toolbox is visible; the ActiveX Controls toolbox option is missing.
Open the VBA editor from the Developer tab in WPS Spreadsheets and make sure the UserForm is open. If the Toolbox is not visible, enable it from View > Toolbox before adding ActiveX controls.
Open Additional Controls from the VBA Toolbox Context Menu
Use this solution when the standard Toolbox is visible but the ActiveX control you need is not listed.
The VBA UserForm Toolbox shows common controls by default. Additional controls are available through the Toolbox context menu and can be enabled per control.
In the VBA UserForm editor, right-click an empty area of the Toolbox window.
Select Additional Controls from the context menu to open the Additional Controls dialog.
Scroll to the required ActiveX control, check its box, and click OK to add it to the Toolbox.

Use the Standard UserForm ComboBox Instead of an ActiveX ComboBox
Use this solution if you only need a combo box on a UserForm and do not require an ActiveX-specific worksheet control.
Add ActiveX Controls in WPS VBA UserForms with WPS Office
WPS Office includes a VBA editor that supports UserForms and lets you enable missing ActiveX controls through Additional Controls, so you can build macro-enabled workbooks without switching applications.
- 1. Open the VBA editor in WPS Spreadsheets: Click the Developer tab, then click Visual Basic to open the VBA editor.
- 2. Open the UserForm editor: In the Project Explorer, double-click the UserForm or insert a new UserForm.
- 3. Display and access additional controls: Right-click the Toolbox and choose Additional Controls to enable the required ActiveX control.
- 4. Insert and save the control: Add the control to the UserForm, then save the macro-enabled workbook.

Frequently Asked Questions
Why can I only see the standard Toolbox in the WPS VBA UserForm editor?
The standard Toolbox shows only common built-in controls. To access ActiveX controls, right-click the Toolbox and choose Additional Controls, then check the control you need.
Can I add an ActiveX combo box to a worksheet in WPS Spreadsheets?
Yes. The same Additional Controls dialog can list available ActiveX controls; however, on a UserForm the built-in ComboBox is often sufficient.
Where is the VBA editor in WPS Spreadsheets?
Enable the Developer tab, then click Developer > Visual Basic to open the VBA editor. If the Toolbox is not visible, enable it from View > Toolbox.
Does WPS Office support macro-enabled Excel files?
WPS Office supports opening and saving .xlsm macro-enabled workbooks and provides VBA editing tools with Microsoft Office format compatibility.




