BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
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.
- Excel VBA Macros - Free On-Line VBA training (this blog)
- What is Excel VBA, and how can you use it?
- Starting to Record Macros in Excel VBA
- Recording your Macro and Finishing
- Tidying up your macro that has been recorded
- Playing back your macro recorded in Excel VBA
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:
- The blog applies equally well to Excel 2003, 2007 and 2010.
- 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.