Chapter 15: Advanced UserForm Techniques

 Download CD Content

Overview

In This Chapter

This chapter picks up where Chapter 14 left off. Here, you'll find additional examples of UserForms.

• Using modeless UserForms

• Displaying a progress indicator

• Creating a wizard - an interactive series of dialog boxes

• Creating a function that emulates VBA's MsgBox function

• Allowing users to move UserForm controls

• Displaying a UserForm with no title bar

• Simulating a toolbar with a Userform

• Allowing users to resize a UserForm

• Handling multiple controls with a single event handler

• Using a dialog box to select a color

• Displaying a chart in a UserForm

• Using an enhanced data form

• Creating a moving tile puzzle

Most of these examples are advanced, and the majority focus on practical applications. But even the less-than -practical examples demonstrate some useful techniques.

CROSS-REFERENCE  

Chapter 28 contains still more UserForm examples. Specifically, you'll find information on how to create a UserForm on the fly.