Excel 2019 Power Programming with VBA

CHAPTER 14Looking at UserForm Examples

IN THIS CHAPTER

• 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 ListBox control
• Using an external control
• Using the MultiPage control
• Animating a Label control

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.

Chapter 15 contains additional examples of more advanced UserForm techniques.

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 is easy, and the code behind the UserForm is straightforward. Each command button has its own procedure for its Click event. For example, the following procedure is executed when CommandButton1 is clicked:

Private Sub CommandButton1_Click()
    Me.Hide
    Macro1
    Unload Me
End Sub 

This procedure hides the UserForm, runs ...