VBA basics
3. Macro recording

Excel macro basics and applications, introduction to Excel VBA
last updated:09-01-2019

3. Macro recording

Some of this topic was processed by machine translation. Original


In explaining the Excel macro, first of all,
You must explain "Recording macros".



It's also called automatic macro recording,
In short, the manual operation of Excel is recorded automatically.
Of course, it is recorded in VBA, the macro language.

In practice, we do not modify and use macro VBA code created from macro recordings.
Do you use it?


When I want to write a certain operation with macro VBA, I don't understand how to write ...
At times like this, it's mainly used to examine it.
For that purpose, you need to be able to use "Record Macro" for the time being.

How to operate "Record Macro"

For the operation method,

Part 1: Recording and executing macro
Let's get started, but before you start, for Excel 2007 and 2010, display the "Development" tab. Check "Show development tab on ribbon" in "Office button" → "Excel options" → "Basic settings". This will display "Development" at the end of the ribbon.
Please refer to this.

How to check when you don't know how to write in VBA

If you don't know how to write in VBA,

Get help
Search online
Check the book


It will be like saying,
In the first place, you don't know what to look for.

Even if you search online, what you want does not hit easily,
This is because the keyword you are looking for does not correctly represent what you want.
"Macro recording" comes in handy to solve this.

Manually operate what you want to do with "Record Macro"
Look at the recorded VBA code
Search for keywords
Check unknown words online

If you do this, you will surely get to the purpose.

When searching the net,
If you can use "Google Custom Search" at the bottom of this page,
The relevant pages in this site will be displayed in a list, so please use it.



Articles with the same theme "VBA basics"

1. What is a macro? What is VBA?
2. First Prepare to use Macro VBA
3. Macro recording
4. Where is the macro written (VBE startup)
5. VBE Set Options (Option Explicit)
6. Let's write it anyway (Sub, End Sub)
7. To run a macro (F5)
8. What is putting a character in a cell (Range, Value)
9. How to specify cells in Range
10. Specification method other than Range (Cells, Rows, Columns)
11. How to use Range and Cells



  • >
  • >
  • 3. Macro recording

  • If you find this site useful, please share and bookmark.


    I'm going to pay close attention to the description,
    If you have any mistakes or suggestions,「Contact Us」I hope you will let me know.
    Use the posted VBA code at your own risk.
    We are not liable for any damages such as data corruption.




    If you find this site useful, please share and bookmark.
    To the bottom of the text