DID YOU KNOW? You can attend any of our instructor-led courses from home. No Travel required!

For more information contact us today:

banner image

Course Information

Course Overview

Get ready to take your Excel applications to the next level by harnessing the power of the VBA language. Excel VBA course will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applications for other users. From introductory concepts to advanced developer topics, it guides you through every aspect of Excel VBA.

Excel VBA course is the perfect introduction to VBA and shows you how to use it to enhance Excel. You'll then learn how to work with the key objects and uncover the best ways to gain access to workbooks, worksheets, and more.

Excel VBA course helps you to create automated spreadsheets for all those repetitive tasks. VBA can also help to simply complex tasks that need to be performed on a regular basis. At the end of the course, users will be able to record and run macros, edit the VBA code, build in looping structures and create custom forms.

Prerequisites

Delegates should have proficient knowledge of Microsoft Excel or should have attended all of the following courses (or similar) prior to this course:

  • Excel Introduction
  • Excel Intermediate
  • Excel Advanced

Outline

  • Introducing Visual Basic for Applications
  • Displaying the Developer Tab
  • Recording a Macro
  • Saving a Macro-Enabled Workbook
  • Running a Macro
  • Editing a Macro in the Visual Basic Editor
  • Understanding the Development Environment Using Visual Basic Help
  • Using Visual Basic Help
  • Understanding Macro Security Working with Procedures and Function
  • Understanding Modules
  • Creating a Standard Module
  • Understanding Procedures
  • Creating a Sub Procedure
  • Calling Procedures
  • Using the Immediate Window to Call Procedures
  • Creating a Function Procedure
  • Naming Procedures
  • Working with the Code Editor
  • Understanding Objects
  • Navigating the Excel Object Hierarchy
  • Understanding Collections
  • Using the Object Browser
  • Working with Properties
  • Using the With Statement
  • Working with Methods
  • Creating an Event Procedure
  • Understanding Expressions and Statements
  • Declaring Variables
  • Understanding Data Types
  • Working with Variable Scope
  • Using Intrinsic Functions
  • Using Intrinsic Constants
  • Using Message Boxes
  • Using Input Boxes
  • Declaring and Using Object Variables
  • Understanding Control-of-Flow Structures
  • Using the If...End If Decision Structures
  • Using the Select Case...End Select Structure
  • Using the Do...Loop Structure
  • Using the For...To...Next Structure
  • Using the For Each...Next Structure
  • Guidelines for use of Control-of-Flow Structures
  • Understanding UserForms
  • Using the Toolbox
  • Working with UserForm Properties, Events,and Methods
  • Understanding Controls
  • Setting Control Properties in the Properties Window
  • Working with Control Appearance
  • Setting the Tab Order
  • Populating a Control
  • Adding Code to Controls
  • Launching a Form in Code
  • Understanding Errors
  • Using Debugging Tools
  • Setting Breakpoints
  • Stepping through Code
  • Using Break Mode during Run mode
  • Determining the Value of Expressions
  • Understanding Error Handling
  • Understanding VBA's Error Trapping Options
  • Trapping Errors with the On Error Statement
  • Understanding the Err Object
  • Writing an Error-Handling Routine
  • Working with Inline Error Handling
Public Dates & Prices
Choose a location...
Remote
Mon 18th May 2020
£595
Remote
Thu 13th Aug 2020
£595
Remote
Thu 5th Nov 2020
£595

If you would like onsite training for this course, request a quote.

course icon
2 Days

Upcoming Public Dates

RemoteMon 18th May 2020£595
RemoteThu 13th Aug 2020£595
RemoteThu 5th Nov 2020£595
More Dates

Testimonials

  • Noel was an excellent tutor. He did check all of the group was able to keep up and if there were any problems or questions of the attendants, he was always willing to help.

    Marianne Seager-Wincanton
  • This was a really good training, nicely paced, very useful and well presented. Thank you, Stuart!

    Joris Latinne-Oracle