-->

Sends keystrokes to the active application.

Excel VBA Examples. First, let’s create a file for us to play around in. Open a new Excel file. Save it as a macro-enabled workbook (. Xlsm) Select the Developer tab. Open the VBA Editor. Let’s rock and roll with some easy examples to get you writing code in a spreadsheet using Visual Basic. Open the Excel sheet and go to the visual basic editor, start the VBA subprocedure VBA Subprocedure SUB in VBA is a procedure which contains all the code which automatically gives the statement of end sub and the middle portion is used for coding. You can also DATE and NOW (VBA Functions) to enter a date or a timestamp in a cell using a VBA code. Range('A1').Value = Date Range('A2').Value = Now And if you want to enter a value in the active cell then the code you need would be like. In this chapter, you will learn to design a simple form and add data into excel. Step 1 − Navigate to VBA Window by pressing Alt+F11 and Navigate to 'Insert' Menu and select 'User Form'. Upon selecting, the user form is displayed as shown in the following screenshot. Step 2 − Design the forms using the given controls.

Syntax

expression.SendKeys (Keys, Wait)

expression A variable that represents an Application object.

Parameters

Name	Required/Optional	Data type	Description
Keys	Required	Variant	The key or key combination that you want to send to the application, as text.
Wait	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.

Remarks

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.

Key	Code
BACKSPACE	`{BACKSPACE}` or `{BS}`
BREAK	`{BREAK}`
CAPS LOCK	`{CAPSLOCK}`
CLEAR	`{CLEAR}`
DELETE or DEL	`{DELETE}` or `{DEL}`
DOWN ARROW	`{DOWN}`
END	`{END}`
ENTER (numeric keypad)	`{ENTER}`
ENTER	`~` (tilde)
ESC	`{ESCAPE}` or `{ESC}`
HELP	`{HELP}`
HOME	`{HOME}`
INS	`{INSERT}`
LEFT ARROW	`{LEFT}`
NUM LOCK	`{NUMLOCK}`
PAGE DOWN	`{PGDN}`
PAGE UP	`{PGUP}`
RETURN	`{RETURN}`
RIGHT ARROW	`{RIGHT}`
SCROLL LOCK	`{SCROLLLOCK}`
TAB	`{TAB}`
UP ARROW	`{UP}`
F1 through F15	`{F1}` through `{F15}`

Where To Enter Vba Code In Excel

You can also specify keys combined with Shift and/or Ctrl and/or Alt. To specify a key combined with another key or keys, use the following table.

To combine a key with	Precede the key code with
Shift	`+` (plus sign)
Ctrl	`^` (caret)
Alt	`%` (percent sign)

How To Enter Vba Code In Excel

Example

The following example creates a new workbook.

The following example displays the Name Manager.

Enter Vba Code In Excel

The following example enters the value 1234 into the Active Cell.

Support and feedback

Vba Code For Enter In Excel

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.