Microsoft KB Archive/106005

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Knowledge Base


Article ID: 106005

Article Last Modified on 10/10/2006



APPLIES TO

  • 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

SYMPTOMS

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.

STATUS

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.

MORE INFORMATION

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:

  1. Select the item in the dialog sheet.
  2. 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.

  1. In the Macro dialog box, click Step.


REFERENCES

"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