excelvbadesignmode

Opening and closing toolbar for design mode

I'm trying to get familiar with VBA in Excel. One of the main things necessary for my first project is creating a UserForm for the end-user to enter the criteria they want to pull data for.

I've gotten a good handle on using the Design Mode toolbox to add text fields, check boxes, etc. to the UserForm when I first generate it:

figure 1

However, if I have to save and exit from VBA before I've finished adding elements to the UserForm, I can't seem to get that toolbox back when I return:

figure 2

I've tried toggling off Design Mode from the Run menu before and after opening the UserForm, right-clicking on the form itself to see what my options are... haven't found a consistent solution yet.

Is there any simple way (either through menus or a keyboard shortcut) to "toggle on and off" the Design toolbox shown in the first image linked above? Regardless of whether it's a pre-existing or brand-new UserForm?

Solution

  • Toolbox can be found under:

    VBA > View > Toolbox

    Here:

    enter image description here