Office-resources-banner

VBA and Macros in Excel - Explained

  • 23 November 2016
  • Author: Liam Phelan
  • Number of views: 3753
  • 0 Comments
 

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.

Macro edit pane

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:

 

Print
Rate this article:
5.0

Please login or register to post comments.

Categories

Subscribe to our Newsletter

cheat sheet resources

Subscribe to our Newsletter for all the latest cheat sheets and resources.

Subscribe