Microsoft KB Archive/106005
Article ID: 106005
Article Last Modified on 10/10/2006
- Microsoft Excel 95a
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0c
- Microsoft Excel 5.0 Standard Edition
- Microsoft Excel 5.0a for Macintosh
- Microsoft Excel 5.0 for Macintosh
This article was previously published under Q106005
In Microsoft Excel versions 5.0 and 7.0, it is not possible to step through a Microsoft Excel 4.0 macro while a custom dialog box is displayed on the screen.
Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed at the beginning of this article. This problem was corrected in Microsoft Excel 97 for Windows and Microsoft Excel 98 Macintosh Edition.
In Microsoft Excel versions 5.0 and 7.0, when you step through a Microsoft Excel 4.0 macro, one of the following situations may occur:
- When a custom dialog box is displayed by the SHOW.DIALOG() command, Microsoft Excel exits step mode and closes the Single Step window before showing the dialog box. -or-
- If a custom dialog box is visible on the screen, if you run the Microsoft Excel 4.0 macro STEP() macro command, you will receive an error message and the macro will halt. -or-
- If a Microsoft Excel 4.0 macro command fails while a custom dialog box is showing, the Step button in the Single Step dialog box will be unavailable (dimmed). -or-
- If the dialog box was displayed by a SHOW.DIALOG() command while in step mode, Microsoft Excel will return to step mode when the dialog box is finally dismissed.
Because it is not possible to step through a Microsoft Excel 4.0 macro while a custom dialog box is showing on the screen, you will need to debug the macro before you run the actual dialog box. To debug a Microsoft Excel 4.0 macro that is called from an item in a custom dialog box, follow these steps:
- Select the item in the dialog sheet.
- On the Tools menu, click Macro.
Microsoft Excel will display the Macro dialog box and will insert the reference of the item's macro into the Macro Name/Reference box.
- In the Macro dialog box, click Step.
"Visual Basic User's Guide", version 5.0, pages 234-239
Additional query words: 5.00a 5.00c 7.00a XL7 XL5 XL
Keywords: kbbug kbfix kbprb kbprogramming KB106005