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.

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?

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.

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...

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

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.

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...

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...

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.

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