Professional Course

Understanding and Using VBA

ACF Academy, In London (+2 locations)
1 day
800 - 925 GBP, 1,150 USD
Next course start
14 December, 2023 (+3 start dates)
Classroom, Virtual Classroom
1 day
800 - 925 GBP, 1,150 USD
Next course start
14 December, 2023 (+3 start dates)
Classroom, Virtual Classroom
This provider usually responds within 48 hours 👍

Course description

Understanding and Using VBA

The Understanding and Using VBA course is an intensive course that gives participants practical expertise in using VBA to enhance the capabilities of Excel.

What really sets our program apart is the way in which we explain, step-by-step, exactly how to harness the power of VBA to create powerful real-world solutions. Our approach demystifies the complexities of using VBA, and gives participants practical skills that they can use to secure immediate benefits.

Participants will have access to a range of fully working VBA examples, and will be able to download these for their own use after the seminar is over.

Do you work at this company and want to update this page?

Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.

Upcoming start dates

Choose between 3 start dates

14 December, 2023

  • Classroom
  • London

24 January, 2024

  • Classroom
  • New York City

25 January, 2024

  • Virtual Classroom
  • Online

Who should attend?

Who Should Attend

Anyone who wants to learn how to expand Excel’s capabilities by using VBA.


A good working knowledge of Excel.

Training content

Introduction to VBA

  • Key uses for VBA
  • Projects, Modules, and Procedures
  • Functions vs. Subroutines
  • Types of variable: integer, double, string, variant, and others
  • Passing parameters to functions and subroutines
  • Passing by value and passing by reference
  • Objects, properties, methods, and events

Programming Structure

  • Declaring variables
  • Scope and lifetime of variables
  • Use of STATIC declaration
  • Declaring arrays
  • Conditional statements
  • Looping structures
  • Defining constants
  • Developing a user-defined function

The VBA Environment

  • Project Explorer
  • Properties Window
  • Code Window
  • Running and Debugging code
  • Setting breakpoints
  • Stepping through the code
  • Stepping into / over / out / run to cursor / set next statement
  • Immediate Window
  • Watch window
  • Adding a Watch
  • Locals Window
  • Call Stack
  • Error handling
  • Error handling within error handling procedures
  • Returning #N/A and #VALUE! Errors from user-defined functions
  • Debugging errors in a UDF

Interfacing VBA with Excel

  • Recording and running macros
  • Excel objects, properties, and methods
  • Working with the methods of specific Excel objects
  • Assigning macros to menus, toolbars and buttons
  • Workbook and Worksheet events
  • Retrieving data from a worksheet
  • Writing data to a worksheet
  • Creating a subroutine / worksheet connection

Interfacing VBA with Databases

  • ADO vs. DAO
  • Creating the connection string
  • Connecting to the database
  • Retrieving recordsets and transferring to Excel
  • Transferring Excel data to the database
  • Data retrieval subroutine example


  • New York: $1,150
  • London:£925 (plus VAT)
  • Virtual: £800 (plus VAT)

Certification / Credits

CPD: 7 hours

Learning Outcomes

By attending this course, you will:

  • Explore the key features of VBA for Excel within a logical framework
  • Develop your skills in working with Excel VBA
  • Enhance your abilities to analyse and debug existing VBA code
  • Examine techniques used for interfacing VBA with Excel and VBA with databases

Why choose ACF Academy?

Over 100,000 professionals trained globally

Award-winning practical financial simulations

Consistently high ratings

Contact this provider

Contact course provider

Tell us what kind of professional training you're looking for and we'll put you in touch with relevant training providers who will send you a quote.

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
ACF Academy
28 King Street
EC2V 8EH London

ACF Academy

ACF Consultants are a global leader in providing practical and effective training for financial professionals. Leading banks, companies and financial institutions from all over the world partner with us to develop their people to achieve their goals. They trust our...

Read more and show all training delivered by this supplier