Excel Visual Basic (VBA) Onsite Training Courses

Course Duration & Prices

Our VBA course is delivered onsite at your own offices over 2 days. These would ideally be two consecutive days, however they could be spread over a week or more if necessary.

Our Microsoft VBA group training rates are as follows (prices are for 2 days):

  • 1 – 3 delegates: £1000
  • 4 – 6 delegates: £1100
  • 7 – 10 delegates: £1200
  • Above 10 delegates: £1200 + £120pp

Please note that these are the total costs per group, not per delegate. For example, if you have 10 employees to put on to a course, you can see that the cost per person equates to just £120. All rates are + VAT. Laptops can also be supplied where required for a small daily rate of £15 each.

VBA 2 Day Training Course

The course includes:

Getting Started with Excel VBA

  • Why use Excel VBA?
  • Recording a Macro
  • Assigning a Macro to a Button
  • Saving as a Macro Enabled Workbook
  • Recording V’s Coding
  • The Visual Basic Editor Environment
  • Navigating between Excel and the VB Editor

Editing Code + Methods of Executing

  • Structure of a Sub Routine
  • Writing your First Code
  • Executing a Sub Routine/Macro
  • Break Mode
  • Using Macro Comments

Visual Basic Language Rules

  • The Object Model Hierarchy
  • Properties and Methods
  • Active Objects
  • Using Inbuilt Functions
  • Adjust VBE Settings
  • Working with Variables

Control Structures

  • IF, Nested IF

Looping Structures

  • Do Loops
  • For Next Loops
  • For Each Next Loops

Interactive Macros

  • Using a Msgbox
  • Use a Conditional Message Box
  • Use the Inputbox

Create Interactive Forms

  • Create a User form for Data Entry
  • Build Form Controls
  • Use of the Properties Window
  • Build a Dialog Box

Using Events

  • What are Event Procedures?
  • Workbook Events
  • Sheet Events
  • Form Control Events
  • The On Time event