Microsoft® Office Excel 2003 Programming Inside Out

Chapter 18. Customizing Dialog Boxes

Displaying Existing Dialog Boxes

Modifying Existing Dialog Boxes

Planning with Dialog Boxes

You don’t have to invent everything on your own when you can use features that already exist. Microsoft Excel gives you access to most of the built-in dialogs within Excel and the other applications in the Microsoft Office System 2003 Edition.

It’s true that your worksheet can be modified using the properties and methods supplied by Visual Basic for Applications (VBA) code. However, if you have variables that the user wants to be able to select while the macro is running, what options do you have? Your first option is to design a User Form, as discussed in Chapter 19. The User Form can have the available options listed, ...