4. Learn VBA - Record a Macro

Nick's picture


Do you find yourself doing the same tasks every day ?
Do you want Excel to automate them ?
This tip is about how to record a macro.
Recording macros is the first step to automate tasks, and to learn VBA.
You can get a decent amount of automation done with this simple procedure.

Step1:
Press the following in sequence:
ALT then t then m then r
That will bring up this screen:
record-macro-excel

Step2:
Press OK, and now do some basic actions like inserting a column.

Step3:
Stop the macro recording:
record-macro-excel

Step4:
Now press ALT and F11, double click on "module1" and look what the macro recorder has recorded.
It will look something like this:
record-macro-excel
Examining the code, we can see that we selected column D, and inserted a column.

Now you attach the code to a button using our first VBA lesson.

Download sheet to practise recording macros, and press the button

Video Training on how to record a macro: