Creating the custom dialog box

These steps create the custom dialog box. Start with an empty workbook.

1. Press Alt+F11 to activate the VBE.

2. If multiple projects are in the Project window, select the project that corresponds to the workbook you're using.

3. Choose InsertOUserForm.

The VBE inserts a new UserForm object with an empty dialog box.

4. Press F4 to display the Properties window.

5. In the Properties window, change the dialog box's Caption property to Change Case.

6. The dialog box is a bit too large, so you may want to click it and use the handles to make it smaller.

Step 6 can also be done after you position all the controls in the dialog box.

Was this article helpful?

0 0

Post a comment