Chapter 15: UserForm Controls
UserForms are customized dialog boxes, and their purpose is to allow users various levels of interaction with Excel. These UserForms contain different controls, from obvious labels and textboxes, to more complex drop-down lists and combo boxes, to command buttons for saving, canceling, or closing the dialog box.
Behind each of these controls (buttons, lists, and so on) is a dedicated procedure, or VBA coding. This VBA code will determine which actions will follow when we click on a button, or select an option from a list, or where data will be stored if we enter information in a textbox.
In this chapter, we will cover the following recipes:
- Assigning controls
- Unloading a form
- Loading the form
- Using the Combo Box control
- Using the SpinButton control
- Setting the tab order
By the end of this chapter, you will be able to show a user form with working controls.
