Microsoft Visual Basic for Excel – VBA

Duration 2 Days

Who should attend?

Those who require the fundamental skills to create useful and powerful VB applications.

Learning Outcomes

  • Work with Command and Function procedures
  • Work with Objects
  • Create User Forms
  • Set options within Excel
  • Observe event handling codes
  • Debug Code

Course Content

  • Introduction to the VBA environment
  • Objects
  • Decision Making Code
  • Code that repeats
  • Using VBA to display information
  • Reading and setting Excel’s options
  • Using Forms
  • Event handling code
  • User defined menus & toolbars
  • Add in Applications
  • Breakpoints and watches
  • The Immediate Window