Microsoft KB Archive/153316

= OnKey Method Ignored When a Dialog Box Is Being Displayed =

Article ID: 153316

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q153316





SYMPTOMS
In Microsoft Visual Basic for Applications, you can use the OnKey method to run a particular macro when a key or key combination is pressed. The OnKey method does not work, however, when a dialog box is being displayed. Dialog boxes, such as message boxes, custom dialog sheets, userforms, and menus cause the OnKey method to ignore the key combination(s) that were set to run the macro.



MORE INFORMATION
This behavior is by design. Dialog boxes are application modal and, therefore, have the application's focus, rendering macros inactive while the dialog boxes are visible.



Excel 97 or Excel 98 Macintosh Edition
For more information about the OnKey method, from the Visual Basic Editor, click the Office Assistant, type OnKey method, click Search, and then click to view "OnKey Method."

NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If the Assistant is not able to answer your query, please see the following article in the Microsoft Knowledge Base:

176476 OFF: Office Assistant Not Answering Visual Basic Questions

Additional query words: 5.00a 5.00c 7.00a XL97 8.00 XL98 XL7 XL5 XL

Keywords: kbprogramming kbprb kbdtacode KB153316

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.