VBA basics
2. First Prepare to use Macro VBA

Excel macro basics and applications, introduction to Excel VBA
last updated:08-13-2019

2. First Prepare to use Macro VBA

Some of this topic was processed by machine translation. Original


Let's make a macro right away.


And before that, there are preparations,

Add a "Development" tab to the top ribbon,

The "Development" tab contains icons necessary for developing macros.

VBA macro excel
* The image will be Excel2019


The preparation operation for using macro VBA is different for each version.

Please make the following preparations for each version you are using.

Excel2003 or earlier

There is no special preparation.

Microsoft's support is out,
Useful features added in later versions will not work, so consider upgrading.

In this series, explanations will be given in Excel 2010 or later unless otherwise noted.
However, there are not many differences between versions.

"Development" tab display in Excel2007

Office button: The button on the upper left.

“Excel Options” at the bottom


"Basic settings" in the left menu

Check to display the "Development" tab on the ribbon, the third from the top

This is OK

This will add "Development" to the ribbon.

"Development" tab display in Excel 2010 or later

"File" on the ribbon

"Option" in the left menu

“Ribbon User Settings” on the left menu

Check "Development" on the right

This is OK

This will add "Development" to the ribbon.



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



  • >
  • >
  • 2. First Prepare to use Macro VBA

  • 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