The information in this article applies to:
SYMPTOMSWhen you step through a Microsoft Visual Basic for Applications macro, the following message may appear: If you click Continue, you can continue stepping through the macro. CAUSEThis behavior occurs when both of the following conditions are true:
WORKAROUNDTo work around this problem when troubleshooting a macro that adds an ActiveX control, use one of the following methods. Method 1: Use another troubleshooting techniqueFor example, use a Debug.Print statement or a watch expression.Method 2: Programmatically add a non-ActiveX control to the worksheetProgrammatically add a non-ActiveX control to the worksheet instead of an ActiveX control. You can find Non-ActiveX controls on the Forms toolbar.Microsoft Excel 97 provides non-ActiveX controls for compatibility with earlier versions of Microsoft Excel. STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. MORE INFORMATION
In Microsoft Excel 97, you can add an ActiveX control to a worksheet to
make a custom application. The ActiveX controls that you can add to a
worksheet appear on the Control Toolbox toolbar. To display the Control
Toolbox toolbar, point to Toolbars on the View menu, and then click
Control Toolbox.
REFERENCESFor more information about ActiveX Controls, click the Index tab in Microsoft Excel Visual Basic Help, type the following text Toolboxand then double-click the selected text to go to the "Toolbox" topic. Additional query words: vbe active x debugging xl97 97
Keywords : kbprg kbdta KbVBA xlwin |
Last Reviewed: October 30, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |