Please note javascript is required for full website functionality.

VBA Blogs

VBA Blogs: An Eventful Month Coming up!

7 July 2017

Over the next few weeks, we’re going to cover a range of Events - these are the actions that can trigger when something happens, such as opening a file, changing sheets, selecting certain cells, and so on.


VBA Blogs: Hidden vs Very Hidden

23 June 2017

We haven’t seen the VBA blog in a little while. So let’s take a look at things we can’t see. If something is hidden, it’s hard to see. Therefore, if something is very hidden, it must be very hard to see, right?


VBA Blogs: Speeding up the Pace of Running Your Macros

19 May 2017

Macros can run pretty slowly when you start working with large files. There are a couple of tricks to improve the speed that your macro runs, relating to a) calculation time, and b) screen updates.


VBA Blogs: Handling VBA Errors

12 May 2017

Last time we were here, we talked about a macro you could use to loop through all of the sheets in a file and unhide them and unprotect them. This presents problems when there are passwords that you're not aware of...


VBA Blogs: Unhiding and Unprotecting Sheets

21 April 2017

Today, we’re going to look at a common application of VBA involving a range of skills that we’ve gone through...


VBA Blogs: For Loops

14 April 2017

Last week, we showed you how to declare variables. This week, we’re going to use a variable to create a loop. Let’s introduce the For loop.


VBA Blogs: Declaring Variables

7 April 2017

One of the most useful things you can do in VBA is to store values in the program’s memory, so that you can use it in the future...


VBA Blogs: If I use VBA Then I get better at it!

24 March 2017

This week, we’re going to cover the use of the IF statement in VBA. This is a very useful tool to help apply conditional rules in macros...


VBA Blogs: Updating your Status (Bar) in Excel

10 March 2017

Last week, we talked about putting a message box into your VBA code. This week, we’re going to look at another useful way of giving information back: the Status Bar.


VBA Blogs: Using Message Boxes in Excel

3 March 2017

This week, we’re going to look at how to set up message boxes in Excel and VBA...


Newsletter