WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 519 reviews for our classroom and online training
How to record macros in Excel Visual Basic
Part one of a six-part series of blogs

If you're not sure what the Excel Visual Basic for Applications language is (or how it can help you) this blog attempts to explain! Learn what VBA is, and how you can record macros and then replay them again and again to automate work in Excel.

  1. How to Record Macros in Excel Visual Basic (this blog)
  2. What is Excel VBA, and how can you use it?
  3. Starting to Record Macros in Excel VBA
  4. Recording your Macro and Finishing
  5. Tidying up your macro that has been recorded
  6. Playing back your macro recorded in Excel VBA

This blog is part of our Excel macros online tutorial series - complemented, of course, by Wise Owl's excellent training courses in VBA and Excel for businesses like yours!

Posted by Andy Brown on 30 June 2011

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

How to Record Macros in Excel Visual Basic

If you've heard of Visual Basic for Applications macros (and feel perhaps you should be using them to be more productive), then this blog is for you!  It explains how to record macros in Excel, and how to play them back to automate common tasks.

First, however, some ground rules:

  1. The blog applies equally well to Excel 2003, 2007 and 2010.
  2. You may find it useful to download the example used throughout this blog.

The blog series tells you what VBA is, how you might use it and how to record and run macros.  If you find the blog inspiring, the next stage is to learn how to write macros in VBA from scratch.

A good place to start, then, is to find out what VBA actually is and does.

This blog has 0 threads Add post