Use the Code Window

Edit Components

Name Your Project

 

ActiveX and VBA Developer's Guide > Getting Started with VBA > Edit Your Projects with the VBA IDE > Edit Components > 

Use the UserForm Window

The UserForm window allows you to create custom dialog boxes in your project.

To add a control simply drag the desired control from the toolbox and place it on the form. You can set your controls to align with the grid of your form from the General tab of the Options dialog box. You can view the form grid and determine the size of the gridlines from the General tab of the Options dialog box. (See Set the VBA IDE Options for more information on the Options dialog box.)

Each form you design will automatically have a Maximize, Minimize, and Close button. These buttons have already been implemented for you.

To add code to the control, simply double-click on the control once it has been placed on the form. This will open a Code window for the control.