VBA: what the FAST modeller needs to know

£49.00 GBP
Regular price
Added to Cart! View cart or continue shopping.

FAST modelling uses macros and Visual Basic for Applications ("VBA") as a last resort.

That's because VBA lacks transparency: even before you can review a macro, you need to know where it is stored and something about the environment in which it sits. It is like opening the bonnet on a car - what is underneath is not necessarily designed with the casual observer in mind. But the FAST modeller needs to have a working knowledge of VBA since there are instances - often on the grounds of productivity and efficiency - where macros have a role to play. There is lots of information available for free on the internet, but little of it is focused on the FAST modeller.

This course is an introduction to VBA that leads to the design and construction of two commonly used macros:

  • a goal seek routine to set an input so that it meets a condition; and
  • a circuit breaker routine to remove a circularity from a model.

On completing the course and its assessments, you will be able to describe the main features of VBA and the environment in which macro coding sits. You will be able to take existing macro coding and use it to build your own macros; you will also be able to investigate how you might build your own coding from scratch.