Microsoft Visual Basic for Excel – VBA

£255.00
Quantity:
Course Dates:

Business Benefit:-

The use of Visual Basic in Excel unlocks the true power of this application. Create powerful yet user friendly applications that will be capable of running critical business processes.

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

IT Skills

Related Products

1