Please note javascript is required for full website functionality.

VBA Blogs

VBA Blogs: Unforget-TABLE, That’s What You Are

10 November 2017

The first in a series about using ListObjects to manipulate Tables within an Excel workbook in VBA.

VBA Blogs: Constants is Her Name

3 November 2017

It is highly recommended that values that are passed into formulae, subroutines and functions are variables. However what if the value of that variable does not change? There is a way to make it immutable by declaring it as a constant.

VBA Blogs: Scoping Variables

20 October 2017

Last weeks’ blog examined the value of declaring variables. But variables can also be used in different subroutines and functions. If there are items that are known to have constant values throughout the entire workbook, they can be declared explicitly in one place...

VBA Blogs: The Value of Declaring Variables

13 October 2017

Take an in depth look of the good coding practice in declaring variables how it helps write better VBA code.

VBA Blogs: Range Modifiers

18 August 2017

Last week we spoke about ranges and how you can refer to them in different ways. This week, we’re going to look at some of the ways you can apply range modifiers to change what set of cells exactly you’re referring to.

VBA Blogs: Referring to Ranges

11 August 2017

There are a number of different ways that we can refer to Excel cells in a worksheet. In the VBA blog series, we’ve been using a fairly consistent approach to referencing cell ranges – that is, using the Range object available in VBA.

VBA Blogs: DoEvents

4 August 2017

It’s a great feeling when you write an involved piece of code with grand loops that apply over thousands of rows. There’s a sweet sensation when you save the file, hit run, and watch your handiwork unfold in front of you… until the screen stops updating...

VBA Blogs: Painting with Excel

21 July 2017

Today we learn how to make something happen when you click on a cell...

VBA Blogs: Save the event!

14 July 2017

This month is Event month! Today, we’re going to be looking at how to set up events to trigger on saving a file.

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.