14.6. Using an Application's Built-in Dialog Boxes from VBA

Some applications, such as Word and Excel, let you use their built-in dialog boxes via VBA. If a built-in dialog box offers the functionality you need, using it can be a great solution: you don't have to build a custom dialog box, just link the built-in dialog box to your code. You shouldn't need to debug the dialog box, and users of your procedures will probably be familiar with the dialog box from their work in the application.

14.6.1. Displaying a Built-in Dialog Box

To display a built-in dialog box, you need to know its name and constant. You also must decide which method to use to display the dialog box.

14.6.1.1. Finding the Dialog Box Name and Constant

Although Office 2007 ...

Get Mastering VBA for Microsoft Office 2007, 2nd Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.