In this chapter students obtain the programming skills needed to write financial VBA programs which require the use of loops, conditional statements, and matrix operations. This topic will describe: Dim statements and option explicit, debugging, data types (as object), the use of functions in functions, for loops and nested loops, arrays and option base 1. | Lecture Financial modeling - Topic 5: Advanced topics in VBA/User-defined functions for use in financial applications
