SHOW.DIALOG

Macro Sheets Only

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 Functions

HIDE.DIALOG Closes the dialog box that has the current focus

List of Customizing Functions