XL: Excel 4.0 Dialog Box Causes Error in Excel 5.0

ID: Q108189

The information in this article applies to:

Microsoft Excel for Windows, versions 5.0, 5.0c
Microsoft Excel for the Macintosh, versions 5.0, 5.0a
Microsoft Excel for Windows 95, version 7.0

SUMMARY

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.

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.

WORKAROUNDS

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.

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.

REFERENCES

"User's Guide 2," version 4.0, pages 274-279.

Additional query words: 4.00

Keywords : kbprg PgmHowto
Version : MACINTOSH:5.0,5.0a; WINDOWS:5.0,5.0c,7.0
Platform : MACINTOSH WINDOWS
Issue type : kbinfo