Microsoft KB Archive/65762

{|
 * width="100%"|

The Equivalent of the SPACEBAR for the SEND.KEYS Function

 * }

-

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:


 * 1) =SEND.KEYS(&quot;%&quot;) 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
 * 2) =SEND.KEYS(&quot;% &quot;) Where the % is the ALT key and the space is the SPACEBAR
 * 3) =SEND.KEYS(&quot;%{ }&quot;) Where the % is the ALT key and the { } is the SPACEBAR

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