Chapter 18
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
Auser 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 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 17, 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.
Adding controls
Oddly enough, the VBE doesn’t ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
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 Visual Basic Editor.