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 ...
Get VBA Automation for Excel 2019 Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
