Contact Us:
+44 1244 940047

To apply for this course please use the button on the right or email us at or give us a call on 01244 940047

Course Information

This hands-on one-day training course has been designed to teach delegates how to apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks that you can perform using various tools and functions in Excel.


Delegates should have already attended, or be familiar with the content of the Microsoft Excel VBA Programming Level 1 course.  Delegates who wish to improve their existing VBA procedure development will find this course beneficial.

Course Overview

  • Calling Procedures
    • Using VBA to run existing procedures
  • Interact with Other Applications
    • Using Excel data in PowerPoint
  • Debugging & Error handling
    • On Error Method
    • Debug Method
    • Using Breakpoints
    • The Watch Window
  • Creating User defined Functions
  • Automatic Procedures
    • Working with Workbook Events
    • Working with Worksheet Events
    • Creating ‘Auto’ Procedures

Course Curriculum

No curriculum found !

Course Reviews


  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.


    About Win Training

    Win Training specialise in a variety of training courses being offered both online and on-premise. Call us today to find out more about how we can help you achieve your training goals +44 1244 940047.

    Who’s Online

    There are no users currently online
    © Win Training.All rights reserved