Adding Controls to a
User Form
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 of adding
two labels and text boxes and giving them appropriate names. The
controls can be easily accessed via their names during the coding
process as you'll see in the next video. |
|
|
|