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.
REFERENCES
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