Special Edition Using Microsoft® Office XP

Secrets of the Office Masters: Custom Dialog Boxes in VBA

Custom dialog boxes in VBA can successfully mimic any dialog boxes you've ever seen in Windows.

In the Three Dog Orders dialog box in Figure 40.21, you see the familiar file tabs that let you flip back and forth between multiple dialog box divisions. There's nothing particularly magical about them—you can draw them yourself, or steal them from, for example, the Support.dot file that's supplied with Office. (Although you wouldn't want to steal a copyrighted picture or duplicate a copyrighted program, dialog box layouts are fair game.) To get all the Word template goodies Microsoft ships with Office, put the installation CD in your drive, choose Add/Remove Programs, expand the Microsoft ...