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.

4 PREV

NEXT

0 0

Post a comment