VBA
Visual Basic for Applications, a programming language embedded in Excel that allows automation of complex tasks, but is not essential for most financial modelers
As defined in JrEAr1x7LaI
Where it comes up · 1
Most important claims · 3 of 3Search all claims for “VBA” →
- Chase encountered a financial model written entirely in VBA at an IT consulting company early in his career where there was significant disconnect between the VBA code and what appeared in the spreadsheet, creating a nightmare for a junior finance person trying to understand the model.Next-Level Financial Modeling with AI and Automation for CFOs with Chase Wright
- Chase does not use circular references, VBA, or external workbook links in his models because they create maintainability and auditability problems; he prefers horizontal layouts, uses VLOOKUP almost exclusively with INDEX MATCH as a secondary option for time-constrained situations, and follows the FAST standard for model designNext-Level Financial Modeling with AI and Automation for CFOs with Chase Wright
- Chase's master's degree in engineering (rather than MBA) was pivotal because it gave him the dual mindset needed to bridge finance and software engineering, enabling him to recognize that VBA models could be replaced with cleaner architectural approaches and later to understand modern data infrastructure integrationNext-Level Financial Modeling with AI and Automation for CFOs with Chase Wright