Excel: Checking Results of a User-Defined Dialog Box

ID: Q32364

The information in this article applies to:

Microsoft Excel for the Macintosh, versions 1.5, 2.0, 3.0, 4.0

SUMMARY

To check the results of a user-defined dialog (UDD), you can insert in your macro immediately after the =DIALOG.BOX() statement, statements that check the Initial/Result column (Column 7) of the dialog box description table.

For example, if you want to check that all Edit fields of a dialog box have been filled in, use an IF() statement such as the following:


   =IF(cellref="",result-if-true,result-if-false)

Where cellref is the cell in the seventh column of the dialog box description table that contains the results returned by the dialog box and result-if-true and result-if-false are the desired actions that depend on the result. The empty quotation marks in the above formula are interpreted as a blank cell.

Additional query words: 1.5 2.2 2.20 3.0 4.00

Keywords :
Version :
Platform :
Issue type :