Chapter 18. Customizing 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, ...
Get Microsoft® Office Excel 2003 Programming Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
