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 7: VBA 5: Creating User Forms and Error Handling

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.


In this module, first of all we build some basic forms. Once we have mastered that, we go on to use VBA to build on-the-fly forms. 

• Option buttons
• Combo box
• List box
• Tick box
• Spinner
• Scroll bar
• Conditional formatting
• Automating form construction with VBA
• Error handling