Within financial modeling circles, there has been a battle concerning the role that Visual Basic for Applications (VBA as it’s commonly known) and the part it should play in the financial modeling life cycle. Every financial modeler will have an opinion about using VBA with two distinct camps: those who advocate the use of VBA and those who believe VBA does not have a place in financial models.
Those new to financial modeling may be curious why such a divide exists, so let’s first take a look at the foundation of VBA to understand its meaning today as a programming language. ...
