Objective: The aim of the course is to learn how to program in VBA to solve complex financial problems using custom dialog boxes for settings.
- Macro recording
- Discovery of the Visual Basic interface
- Algorithmic: loops and conditions
- Functions and procedures
- Variables, arrays and VBA objects
- The forms
- Error management and automation
Grading: Interrogation on computer at the end of the semester and project.