CHAPTER 15
Implementing Advanced UserForm Techniques

---

IN THIS CHAPTER

• 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
• Emulating a task pane 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
• Creating puzzles and games with UserForms

---

A Modeless Dialog Box

Most dialog boxes that you encounter are modal dialog boxes, which you must dismiss from the screen before the user can do anything with the underlying application. Some dialog boxes, however, are modeless, which means that the user can continue to work in the application while the dialog box is displayed.

To display a modeless UserForm, use a statement...