The Equivalent of the SPACEBAR for the SEND.KEYS Function

ID: Q65762

The information in this article applies to:

Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 5.0
Microsoft Excel for OS/2, versions 2.2, 3.0

SUMMARY

When using the SEND.KEYS function in Microsoft Excel, the equivalent key code for the SPACEBAR is either a space, a space inside parentheses, or a space inside braces. An example of using the SEND.KEYS function with the SPACEBAR would be to pull down the Control menu (-) in Microsoft Excel. The following are three lines that can do this:

=SEND.KEYS("%( )") Where the % is equivalent to the ALT key; the space inside the parentheses is equivalent to the SPACEBAR; and the parentheses around the space are equivalent to pressing the ALT key while pressing the SPACEBAR

=SEND.KEYS("% ") Where the % is the ALT key and the space is the SPACEBAR

=SEND.KEYS("%{ }") Where the % is the ALT key and the { } is the SPACEBAR

(Note: this is true for version 5.0 macro sheets, but not modules.)

REFERENCES

"Online Help," version 5.0
"Function Reference," version 4.0, page 385
"Function Reference," version 3.0, pages 214-215
"Functions and Macros," version 2.1, pages 353-354, 373

Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 4.0 4.0a 4.00a 5.0

Keywords :
Version :
Platform :
Issue type :