Displaying Built-in Dialog Boxes

In Microsoft Excel version 4.0, to display built-in dialog boxes while running a macro, you use the question-mark form of the macro function corresponding to the dialog box. For example, the DEFINE.STYLE? macro function displays the dialog box used to define worksheet styles.

In Microsoft Excel version 7.0, to display built-in dialog boxes while running a procedure, you use the Dialogs method with the identifier of the dialog box you want displayed. For example, the following procedure displays the dialog box for the Open command ( File menu).

Sub OpenFile()
    Application.Dialogs(xlDialogOpen).Show
End Sub