Microsoft KB Archive/32364

{|
 * width="100%"|

Excel: Checking Results of a User-Defined Dialog Box

 * }

-

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=&quot;&quot;,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 :

Technology :