We also offer courses and publications in: UK Flag London US Flag New York
  • Join us for the latest updates, tips and course dates!

Excel - Module 5: VBA 3: Using Control Structures

Excel gives you the edge whenever you want to do something new with financial models, something never seen before in instrument pricing, and something that none of your competitors has ever done.
Delivered via Virtual Classroom you will be able to engage with the instructor and other participants, share screens, ask questions without leaving your office or your home, city or country.


Like all programming languages, VBA contains various control structures. In this module we examine and use all of the main ones.

• If statement

• If Then Else statement
• For Next loop
• For Each loop
• Do Until loop
• Do While loop
• Select Case
• Stepping through code