Excel 2007 Power Programming with VBA (Mr. Spreadsheets Bookshelf)
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.