In This Chapter
This chapter presents many useful and informative examples that introduce you to some additional techniques that involve UserForms.
Using a UserForm for a simple menu
Selecting ranges from a UserForm
Using a UserForm as a splash screen
Changing the size of a UserForm while it’s displayed
Zooming and scrolling a sheet from a UserForm
Understanding various techniques that involve a
Using an external control
You might be able to adapt these techniques to your own work. All the examples are available on the CD-ROM that accompanies this book.
Chapter 15 contains additional examples of more advanced UserForm techniques.
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: using CommandButtons or using a ListBox.
Figure 14-1 shows an example of a UserForm that uses
CommandButton controls as a simple menu. Setting up this sort of thing is very easy, and the code behind the UserForm is very straightforward. Each CommandButton has its own event handler procedure. For example, the following procedure is executed when
CommandButton1 is clicked:
Figure 14-1. This dialog box uses CommandButtons ...