Excel: Checking Results of a User-Defined Dialog BoxLast reviewed: November 29, 1994Article ID: Q32364 |
The information in this article applies to:
SUMMARYTo 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
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |