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.