Modelling In Excel, How To Teach an Old Dog, New Tricks
Paul T. Shannon · 2008
Microsoft Excel, for many years has been used as a generic tool in many industries for a wide range of analyses and modelling. Thanks, in part to the scope of Visual Basic for Applications (VBA); the programming language behind Excel’s macro functionality. However, VBA has seen very limited development over the past decade. Consequently, this has resulted in model developers and users looking away from Excel in order to build a realworld, Graphical User Interface (GUI) for such models. Fortunately though, an old dog can learn new tricks. It is now possible to build a GUI within Excel, based on web languages, giving the look and feel of GUI’s a 21st century application, without using external software to achieve this.