Activex Controls For Excel Code Module Of

When a form is added to a project, the Control Toolbox should automatically appear (see Figure 6.3).

If the Control Toolbox does not appear, select ViewToolbox from the menu bar.

To practice using ActiveX controls on forms, open Excel and from the VBA IDE, insert a form into a new VBA project.

Adjust the size properties (Width and Height) of the UserForm object and change its Caption property to Hello.

Add Label and Command Button controls to the form and change their Name properties to something meaningful (for example, lblOutput, and cmdHello).

Also, adjust the size and appearance properties of the Label and Command Button controls to suit your taste.

Activex Controls For Excel Code Module Of

Next, double-click on the Command Button control to access its Click() event procedure in the code module of the UserForm object and add one line of code such that the entire procedure appears as follows.

To close the form, click on the X in the upper-right corner of the window.

Activex Controls For Excel Mac