Custom Dialog Box Alternatives

In This Chapter

^ Saving time by using any of several alternatives to custom dialog boxes ^ Using the InputBox and MsgBox functions to get information from the user ^ Getting a filename and path from the user

^ Writing VBA code to display any of the Excel built-in dialog boxes

■ Xou can't use Excel very long without being exposed to dialog boxes.

They seem to pop up almost every time you select a command. Excel — like most Windows programs — uses dialog boxes to obtain information, clarify commands, and display messages. If you develop VBA macros, you can create your own dialog boxes that work just like those built into Excel.

This chapter doesn't tell you anything about creating custom dialog boxes. Rather, it describes some techniques you can use in place of custom dialog boxes. (The next three chapters tell you everything you need to know to jazz up your applications with some award-winning dialog boxes.)

0 0

Post a comment