VBA

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.

Outline:

• Macro recording
• Discovery of the Visual Basic interface
• Algorithmic: loops and conditions
• Functions and procedures
• Variables, arrays and VBA objects
• Methods
• The forms
• Error management and automation

Grading: Interrogation on computer at the end of the semester and project.