How To Use This Website

VBA Get Started

“The beginning is the most important part of the work.” – Plato

If you are new to VBA then you may be overwhelmed with all the information on the website. Don’t worry – I have written this quick and easy guide to help you get started.

 

Getting Excel ready for VBA

If you are creating a macro for the first time then you need to spend a few minutes getting set up. Follow the instructions here: How To Create a Macro From Scratch in Excel. Once you are set up you won’t need to do most of these steps again.

 

Brand New to Excel Macros?

If you are a complete beginner in Macros/VBA then the best place to start is with The Ultimate VBA Tutorial. It was written specifically for the beginner. It is packed full of explanations, activities, code examples and an end of section quiz.

 

Finding things on this site

To see a list of all the posts by category, you can go to the home page(ExcelMacroMastery.com).

You can also get here by clicking on the Contents link in the left-hand sidebar(see screenshot below)

 

 

To search for specific keyword(s) you can use the Search box which is also in the left-hand panel(see screenshot below)

Search Box

 

Ranges

Almost everything you do in Excel VBA involves a range of one or more cells.  I have written an in-depth post about ranges which starts at the basics and covers all the important things you need to know.

Check it out at: Complete Guide to Ranges and Cells in Excel VBA.

 

Workbooks and Worksheets

When you perform task that involves ranges, you need to determine the worksheet and workbook to use. There are many ways to access both of these in VBA. This often leads to confusion.

The following posts will help you easily manage workbooks and worksheets in the best way possible
The Complete Guide To The VBA Worksheet
The Complete Guide To The VBA Workbook

 

The For Loop

Loops are the powerhouse of VBA. They allow you to perform a massive number of tasks in seconds.

For example, you can read through 10000 rows of data and check each one for a particular piece of text. Doing this manually could take hours.

VBA has two types of For loops: The standard For Loop and the For Each Loop. You can find out all about them here

In VBA, we have two other loops: the Do Loop loop and the While Wend Loop.

Generally speaking, it is rare that you need to use these in VBA. However, it is good to know about them for when that rare case arises.

You can read more about these loops here: VBA While Loop – A Complete Guide

 

Subs and Functions

In VBA we place our code in Subs(or the very similar Functions). When most people start with VBA they tend to place all their code in one large Sub. However, by using lots of small subs we can make our code more flexible, more efficient and easier to update.

You can read all about Subs(and Functions) here: The Complete Guide to the VBA Sub

 

Data Structures

We use data structures to store groups of similar data. They are essentially groups of variables.

In VBA our data structures are the Array, the Collection and the Dictonary.

If you are completely new to data structures then the post on arrays is the best one to start with. I wrote this post with complete beginners in mind.

 

What’s Next

Once you have a firm understanding of the above topics you may want to move onto more advanced techniques and topics.

At this point what you need to learn really depends on the type of application you are creating and what you are trying to achieve.

You can check out all the blog posts by category on the contents page.

You can also check out my YouTube channel where I host regular free live workshops on VBA.