Microsoft Excel Training Videos

Adding controls to the user form in Excel

To add controls to a user form like a command button, find the control you want to add in the Excel ToolBox, drag the control onto the form, and then drag an adjustment handle on the control until the control's outline is the size and shape you want.
When you've added controls to the form, use the commands on the Format menu in the Visual Basic Editor to adjust the control alignment and spacing. The Excel training video shows the complete process in action.




Further Reading

Macros: adding controls to user form