April 2006
Beginner
1114 pages
98h 16m
English
Application.Dialogs(XlBuiltInDialog)
Returns the collection of Excel’s dialog boxes. Use Dialogs to display any of the Excel dialog boxes from code. The following code displays the Activate Workbook dialog box:
Sub TestDialogs( )
Application.Dialogs(XlBuiltInDialog.xlDialogActivate).Show
End SubExcel has hundreds of dialog boxes. See Appendix A for a list of them.
Read now
Unlock full access