CHAPTER 14
Looking at UserForm Examples
Creating a UserForm “Menu”
Sometimes, you might want to use a UserForm as a type of menu. In other words, the UserForm presents some options, and the user makes a choice. This section presents two ways to do this: by using command buttons and by using a list box.
Using CommandButtons in a UserForm
Figure 14.1 shows an example of a UserForm that uses command buttons as a simple menu.
FIGURE 14.1 This dialog box uses command buttons as a menu.
Setting up this sort of UserForm...
