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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.