Dialog Box and Form Objects
Excel’s Dialogs collection lets you display any of the application’s built-in dialog boxes or get information from one of Excel’s file dialog boxes. However, you display custom dialog boxes using the Microsoft Forms object library
—not the Excel object library. Figure 4-19 shows the dialog box objects from both object libraries.
Figure 4-19. Objects for displaying dialog boxes
Tip
Early versions of Excel used the DialogSheets collection to display custom dialog boxes, but that technique is now obsolete.
Get Programming Excel with VBA and .NET 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.
