VBA & Macro Problems

How to Display the ActiveX Controls Toolbox in WPS VBA

Emma BrownEmma Brown Nov 13, 2026 870 views

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.

How to Display the ActiveX Controls Toolbox in WPS VBA
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.
Before you start

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.

Solution 1Recommended

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.

1
Right-click the Toolbox

In the VBA UserForm editor, right-click an empty area of the Toolbox window.

2
Choose Additional Controls

Select Additional Controls from the context menu to open the Additional Controls dialog.

3
Select the ActiveX control

Scroll to the required ActiveX control, check its box, and click OK to add it to the Toolbox.

Open Additional Controls from the VBA Toolbox Context Menu
Toolbox updated: The selected ActiveX control now appears in the Toolbox and can be inserted into the UserForm.
WPS VBA Macro Support

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. 1. Open the VBA editor in WPS Spreadsheets: Click the Developer tab, then click Visual Basic to open the VBA editor.
  2. 2. Open the UserForm editor: In the Project Explorer, double-click the UserForm or insert a new UserForm.
  3. 3. Display and access additional controls: Right-click the Toolbox and choose Additional Controls to enable the required ActiveX control.
  4. 4. Insert and save the control: Add the control to the UserForm, then save the macro-enabled workbook.
Enable ActiveX controls in the VBA toolbox directly in WPS SpreadsheetsFamiliar VBA UserForm editor with Developer tab accessFree and lightweight alternative to Microsoft OfficeOpens and saves macro-enabled .xlsm Excel files for format compatibility
microsoft office alternative - wps office

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.