'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Missing ActiveX Control Toolbox in Excel VBA UserForm
Question details
The user needs to locate and add missing ActiveX controls to the Toolbox when building an Excel VBA UserForm.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Creating or modifying a VBA UserForm where specific UI elements like calendars or progress bars are needed.
- Observed behavior
- The ActiveX Control Toolbox does not display the necessary controls required for the UserForm.
Ensure you have the Developer tab enabled in your Excel ribbon and that your current workbook is saved as a Macro-Enabled Workbook (.xlsm).
Enable Additional Controls via the Toolbox Shortcut Menu
Manually add the missing ActiveX controls directly into the VBA Toolbox using the shortcut menu.
By default, the VBA Toolbox only shows standard controls. Additional ActiveX controls installed on your system can be enabled easily through the Additional Controls dialog.
Press Alt + F11 on your keyboard to open the Microsoft Visual Basic for Applications (VBA) editor.
In the Project Explorer, insert a new UserForm or double-click an existing one to display the Toolbox. If the Toolbox does not appear, click View > Toolbox from the top menu.
Right-click anywhere inside the blank space of the Toolbox and select 'Additional Controls' from the shortcut menu.
Scroll through the list of available controls, check the boxes next to the ActiveX controls you want to add, and click 'OK'.
Use WPS Spreadsheet for Seamless Macro and VBA Support
WPS Office provides robust support for VBA macros and UserForms. You can easily create, edit, and run VBA scripts just as you would in Microsoft Excel, enjoying a familiar interface and comprehensive developer tools.
- 1. Download and Install: Download WPS Office Free from the official website and install it on your computer.
- 2. Open your Workbook: Launch WPS Spreadsheet and open your Macro-Enabled Workbook (.xlsm).
- 3. Access the Developer Tools: Go to the Developer tab on the ribbon to access the VBA Editor, Macros, and security settings.
- 4. Manage UserForms: Open the VBA Editor, insert a UserForm, and utilize the built-in toolbox for ActiveX controls seamlessly.
Frequently Asked Questions
Why is my VBA Toolbox completely hidden?
The Toolbox only appears when a UserForm is active. To show it, click on a UserForm in the Project Explorer, then go to View > Toolbox in the top menu, or click the Toolbox icon on the standard toolbar.
Why is the 'Additional Controls' option greyed out?
This typically happens if your VBA code is currently running or in break mode. Stop the debugger by clicking the 'Reset' (square) button on the toolbar, and the option will become available again.
Can I reset the VBA Toolbox to its default settings?
Yes. You can reset the Toolbox by closing Excel, navigating to your user AppData directory, and deleting the temporary .exd files (such as MSForms.exd). Excel will rebuild the toolbox to its default state the next time you open the VBA Editor.
