Chapter 12: Custom Dialog Box Alternatives

 Download CD Content

Overview

In This Chapter

Dialog boxes are, perhaps, the most important user interface element in Windows programs. Virtually every Windows program uses them, and most users have a good understanding of how they work. Excel developers implement custom dialog boxes by creating UserForms. However, VBA provides the means to display some built-in dialog boxes. This chapter covers the following topics:

• Using an input box to get user input

• Using a message box to display messages or get a simple response

• Selecting a file from a dialog box

• Selecting a directory

• Displaying Excel's built-in dialog boxes

Before I get into the nitty-gritty of creating UserForms, you might find it helpful to understand some of Excel's built-in tools that display dialog boxes. That's the focus of this chapter.