Examples To Use Excel VBA SendKeys Method - WallStreetMojo

All Courses LoginAll BlogsVBA ResourcesVBA SendKeysVBA SendKeys

Publication Date :

16 Nov, 2019

Blog Author :

Jeevan A Y

Edited by :

Ashish Kumar Srivastav

Reviewed by :

Dheeraj Vaidya, CFA, FRM

Share

GET: WSM ALL COURSES ACCESSDownload FREE VBA SendKeys In Excel Template and Follow Along!VBA SendKeys Excel Template.xlsm

Table Of Contents

Excel VBA SendKeys

SendKeys in VBA language is a method to send keystrokes to the active window so we can work manually after that. Whenever we use alphabets as the keys, all the alphabets need to be in lowercase characters. It is a complex method and recommended to use only if necessary and when you are out of options.

"SendKeys" is one of the more complex topics to understand. Not many of us use this feature in VBA, but it is always good to have more knowledge on more topics. This article will show you how to use the SendKeys function. You may find it difficult to reread the article multiple times with a practical approach to learn fast and better.

Syntax

Below is the syntax of the VBA SendKeys method:

Keys or String: The kind of key that we need to send to the active application.

Wait: In this argument, we can use two things: TRUE or FALSE.

• TRUE if you want the Excel to wait for the assigned Keys to process before returning the control to the Macro.
• FALSE if you ignore the Wait parameter, this will be the default value. If you choose FALSE, Excel continues to run the Macro without waiting for the keys to process to the active window.

We use the keyboard's common keys: "Ctrl, Shift, and ALT." So, with the SendKeys method, we need to use them with special characters. The below table shows the special characters for the above three common keys.

Key	Character	Character Description
Ctrl	^	Caret
Shift	+	Plus Sign
ALT	%	Percent Sign

Other keys have different keys and characters. The below table shows the detailed explanation for each key.

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}
ESCAPE	{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}

As per the requirement, we can use any of the above keys. With some practical examples, we will show you how to use SendKeys.

Examples to use Excel VBA SendKeys Method

Example #1

Look at the below cell value.

We have values in three cells. For example, in the first cell, we have a value of "Bangalore." So for this cell, there is a comment as the "Capital City of Karnataka."

Now, using "SendKeys," we try to edit this comment.

Open the Excel sheet. Go to the Visual Basic Editor, and start the VBA subprocedure.

Code:

Sub Send_Keys_Example() End Sub

First, we need to select the comment cell to edit the comment. So, use the code RANGE("A1").Select

Code:

Sub Send_Keys_Example() Range("A1").Select End Sub

Once the cell is selected, we will act on editing the comments. Here, we must recollect the keyboard shortcut we used to edit the comment.

We use the shortcut key "Shift + F2" to edit the comment.

If you press this key, it will edit the comment.

Now, open the "SendKeys" method.

In the SendKeys method, the character for using the SHIFT key is "+" (Plus sign), so enter the "+" sign-in code.

Now, plus sign works as a SHIFT key. The next key, along with SHIFT, we use is the F2 key. We need to enclose function keys with curly brackets whenever we use function keys. So, enter the function key F2 in the curly bracket.

Code:

Sub Send_Keys_Example() Range("A1").Select SendKeys "+{F2}" End Sub

Now execute the code and see what we get.

When we tried to execute the code, we got the message above. One of the key things we need to keep in mind is we cannot run the Macro, which uses "SendKeys" from the Visual Basic Editor window.

We need to run the code from the "Macro" list.

Close the Visual Basic Editor Window first.

Go to the “Developer” tab and click on “Macros.”

Now, a list of all the Macros opens up. Choose the Macro that you need to run. Our Macro name is "Send_Keys_Example," so we will press the "Run" button.

You can see that the "Edit" comment option is enabled.

As you can see above, it has assigned the shortcut key of SHIFT + F2 to open the edit comment option.

Example #2

We can do this if you want to open the “Paste Special” window through the SendKeys method. But, first, we need to copy certain cells and then use the SendKeys.

Code:

Sub Send_Keys_Example1() Range("A1").Copy SendKeys "%es" End Sub

Choose the Macro you need to run and click on "Run."

When you run the code, it will open below the Paste Special dialog box.

Things to Remember

• The SendKeys assigns keystrokes to the active application.
• This method is complex and recommended only if necessary and when you are out of options.
• Whenever we use alphabets as the keys, all the alphabets need to be in lowercase characters.

FINANCIAL MODELING 2-DAY BOOTCAMP @70% OFF – YEAR END SALE

Master Financial Modeling in Just 2 Days | Build and Forecast IS, BS & CF from Scratch | Perfect for Graduates and Professionals Looking to Upskill This SALE.

Join WallStreetMojo YouTube

INVESTMENT BANKING MASTERY PROGRAM @70% OFF – YEAR END SALE

Experience the Exact Training Used by Top Investment Banks | Learn FM, DCF, LBO, M&A, Accounting & More | Unlock Wall Street-Level Skills This SALE.

Join WallStreetMojo Instagram

CHATGPT & AI FOR EXCEL COURSE @70% OFF – YEAR END SALE

Boost Productivity 10X with AI-Powered Excel | Automate Reports, Eliminate Errors & Advance Your Analytics Skills | Transform Your Workflow This SALE.

Join WallStreetMojo LinkedIn

EXCEL ALL-IN-ONE BUNDLE COURSE @70% OFF – YEAR END SALE

Master Excel, VBA & Power BI Like a Pro | 70+ Hours of Expert-Led Training | Learn Real-World Applications & Earn Your Certification This SALE.

Join WallStreetMojo Facebook

Join WallStreetMojo X