To Size a Control As it is Placed (VBA)

As a control is placed, you can adjust is size and placement in the UserForm window of the VBA IDE.

1. Select the desired control in the control toolbox.
2. On the form, press, drag, and release the mouse button. The selected control will be placed on the form. The size of the control depends on how far you drag the mouse.