Excel: Checking Results of a User-Defined Dialog Box

Last reviewed: November 29, 1994
Article 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.


KBCategory: kbother
KBSubcategory:

Additional reference words: 1.5 1.50 2.2 2.20 3.0 3.00 4.0 4.00


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.