Custom Dialog Box Alternatives


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. To that end, I cover the following:

♦ 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.

0 0

Post a comment