XL: OnKey Method Ignored When a Dialog Box Is Being Displayed

• Microsoft Excel 98 Macintosh Edition
• Microsoft Excel 97 for Windows
• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a

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.

For additional information, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q133136
   TITLE     : Using the OnKey Method in a Visual Basic Macro

REFERENCES

For more information about the OnKey method in Visual Basic for Applications, click Search in Visual Basic Reference Help and type:

   OnKey