This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Download Microsoft Edge
More info about Internet Explorer and Microsoft Edge
Syntax
expression
.
SendKeys
(
Keys
,
Wait
)
expression
A variable that represents an
Application
object.
Parameters
Required/Optional
Data type
Description
Required
Variant
The key or key combination that you want to send to the application, as text.
Optional
Variant
True
to have Microsoft Excel wait for the keys to be processed before returning control to the macro.
False
(or omitted) to continue running the macro without waiting for the keys to be processed.
This method places keystrokes in a key buffer. In some cases, you must call this method before you call the method that will use the keystrokes. For example, to send a password to a dialog box, you must call the
SendKeys
method before you display the dialog box.
The
Keys
argument can specify any single key or any key combined with Alt, Ctrl, or Shift (or any combination of those keys). Each key is represented by one or more characters, such as
"a"
for the character a, or
"{ENTER}"
for the Enter key.
To specify characters that aren't displayed when you press the corresponding key (for example, Enter or Tab), use the codes listed in the following table. Each code in the table represents one key on the keyboard.
Application.SendKeys("%mn")
The following example enters the value 1234 into the Active Cell.
Application.SendKeys ("1234{Enter}")
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
