Speeding up VBA Code using Calculation Mode

One of the most common requests from people writing VBA code in Excel is “how do I speed up my VBA code?”. The Speeding up VBA Code series aims to give you some quick and easy to implement techniques to speed up your code. In this free beginner level Excel tutorial we use Microsoft Excel…

The Value of a Forward Contract

The value of a forward contract and the forward price of an asset are something we will use again and again in various places.  Of equal importance are the techniques we can use to arrive at the equations for these.  We begin with some definitions and then I will take you though my thought process…

Goal Seek in Excel … Done Correctly!

Building a spreadsheet that uses Goal Seek to get to the end result is relatively easy. Doing it well takes a bit more work. In this beginner level tutorial we start with a typical spreadsheet that uses Goal Seek. It works but it’s difficult for a new user to follow and figure out what they…

Conditional Compile in VBA

In Microsoft Excel and Access, when coding in Visual Basic for Applications (VBA) we can use conditional compile to create multiple versions of our compiled code. This is extremely useful when we want to create different versions for different platforms (e.g. 32 bit or 63 bit … or windows vs Mac). We can also use…