Article ID: 108189
Article Last Modified on 10/11/2006
APPLIES TO
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0 Standard Edition
- Microsoft Excel 5.0c
- Microsoft Excel 5.0 for Macintosh
- Microsoft Excel 5.0a for Macintosh
This article was previously published under Q108189
SYMPTOMS
If you run a Microsoft Excel 4.0 macro in Microsoft Excel version 5.0 and
later with a dialog box that contains an undefined item number, you may
receive the following error message:
Error in dialog at MacroSheetName!Cell_Reference
where Cell_Reference refers to the undefined item number. You will then
receive a macro error at the cell containing the DIALOG.BOX() function.
This same macro will run without error in Microsoft Excel 4.0.
WORKAROUND
To work around this problem, do either of the following:
- Change the order in which the items are listed so the undefined item
number comes BEFORE the option button, not after it.
-or-
- Create the dialog box in either a Microsoft Excel version 5.0 or 7.0
dialog sheet and use the visible property to hide and unhide the object
in the dialog box.
MORE INFORMATION
In Microsoft Excel 4.0, your dialog box definition table can contain
undefined dialog box items. These undefined items are used to hide an item
on the dialog box. However, when the undefined item number follows an
option button (item number 12), Microsoft Excel versions 5.0 and 7.0 will
report the above macro error messages.
For a list of dialog box item numbers, see pages 274-279 of "User's Guide
2," version 4.0.
REFERENCES
"User's Guide 2," version 4.0, pages 274-279.
Additional query words: 4.00
Keywords: kbprb kbprogramming KB108189