Microsoft KB Archive/40156

Sending Keys to Dialog Boxes in Excel for Windows PSS ID Number: Q40156 Article last modified on 09-14-1993 PSS database name: W_eXceL

2.00 2.01 2.10 3.00

WINDOWS

Summary:

In Microsoft Excel you can send key sequences to all dialog boxes that are not “system modal” by using the SEND.KEYS macro command.

Windows dialog boxes are either “modal” or “modeless.” A modeless dialog box is one that allows you to switch to other windows within the program or to other programs while the dialog box is displayed. A modal dialog box does not allow you to switch between the dialog box and another window in the program.

A modal dialog box allows you to switch to another application while the dialog box is displayed. However, a specific type of modal dialog box, called “system modal,” halts all other events in Windows until the dialog box is ended. Examples of system modal dialog boxes are those dialog boxes brought up from the MS-DOS Executive File menu (for example, File Copy, File Print, etc.).

Additional reference words: 2.00 2.01 2.10 3.00 fill fillin enter answer

Copyright Microsoft Corporation 1993.