Runs a dialog on a dialog sheet.
Syntax
SHOW.DIALOG(dialog_sheet)
Dialog_sheet is the name of the dialog sheet to run. If omitted, the active sheet will be the sheet that is run. If this function is run on a sheet other than a dialog sheet, this function returns the #VALUE error value.
Remarks
Returns TRUE if the dialog box is closed by the user choosing an OK button. Returns FALSE if the dialog box is cancelled by choosing the Cancel button or the ESC key, or in Microsoft Excel for the Macintosh by pressing COMMAND+. (period).
Related Function
HIDE.DIALOG Closes the dialog box that has the current focus
Return to index