VBA (Visual Basic for Applications) is the programming language of Excel that allows you to automate tasks utilising what we call macros. Basically, VBA is the tool we use to develop programs to control and automate functions in Excel.

Well probably the best way to understand it, is to see how it's done.

How to record and then view the recorded VBA code

Go to the Developer tab (If not already enabled) go to File>>Options>>Customise Ribbon>>Tick the “Developer” tab

Click record Macro

 Once you do that you get the following pop up for Recording the Macro:

This gives you the option to name, create a shortcut, store the Macro and add a description.

Once you have filled in the details, click OK to start recording your first Macro.

There are millions of steps and repeated procedures that you can perform for use with a Macro.

When you are finished recording the steps for your Macro, click the stop Square recording button in the Code group.

To Play, edit etc… Click Marcos button in the Code group

Options let you add a description or to edit or create a shortcut.

Edit option will let you edit the actual code in VBA for the steps you recorded in your Macro.

For more on recording Macros and VBA please see our Excel Part 3 course and our Excel VBA course.

 

---

 

You may also be interested int he following courses:

 

• Excel 2013 Programming with VBA
• Excel 2013 Tables, PivotTables and Conditional Formatting
• Excel 2013: Data Analysis with Pivot Tables
• Excel 2013: Data Analysis with Pivot Tables
• Excel 2013: Data Analysis with Power Pivot
• Excel 2013: Data Analysis with Power Pivot