Designing the Form

From the sample files for this book, open the workbook named UserForm.xlsm. This file contains the Customer Survey database shown in Figure 4-1. Our custom form will collect and save its data to this table.

Figure 4-1. The Customer Survey database

Figure 4-1. The Customer Survey database

Open the VBE, and add a UserForm to the project. You can do this by choosing Insert > UserForm, or you can right-click in the Project Explorer window and choose Insert > UserForm, as shown in Figure 4-2.

Figure 4-2. Adding a UserForm to the project

A new empty UserForm named UserForm1 is added to the project, as shown in Figure 4-3.

Figure 4-3. New UserForm with Toolbox and Property Sheet displayed

Along with the UserForm, you'll see the Toolbox window, which contains a palette of controls to use, and the UserForm Property Sheet, where you can rename your form and modify various settings.

The Toolbox controls are described in Table 4-1.

0 0

Post a comment