Excel VBA Programming For Dummies, 3rd Edition

Chapter 17

Using UserForm Controls

In This Chapter

Understanding each type of dialog box control

Changing each control’s properties

Working with dialog box controls

A user responds to a custom dialog box (also known as a UserForm) by using the various controls (buttons, edit boxes, option buttons, and so on) that the dialog box contains. Your VBA code then makes use of these responses to determine which actions to take. You have quite a few controls at your disposal, and this chapter tells you about them.

If you worked through the hands-on example in Chapter 16, you already have some experience with UserForm controls. This chapter fills in some of the gaps.

Getting Started with Dialog Box Controls

In this section, I tell you how to add controls to a UserForm, give them meaningful names, and adjust some of their properties.

Before you can do any of these things, you must have a UserForm, which you get by choosing Insert⇒UserForm in the VBE. When you add a UserForm, make sure that the correct project is selected in the Project window (if more than one project is available).

Adding ...