Excel VBA Programming For Dummies, 6th Edition

Chapter 17

Using UserForm Controls

IN THIS CHAPTER

Understanding each type of dialog box control

Changing each control’s properties

Manipulating dialog box controls in your UserForm object

A user responds to a custom dialog box (also known as a UserForm) by using the various controls (buttons, text boxes, option buttons, and so on) that the dialog box contains. Your VBA code then uses 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, you explore 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 need a UserForm. Add a UserForm to your project by selecting the project in the Project Explorer and choosing Insert  ⇒    UserForm in the VBE.

Adding controls

Oddly enough, the VBE doesn’t have ...