Microsoft Excel Logo Training

Onsite Microsoft Visual Basic training

Onsite Microsoft Visual Basic Training Sessions

If you or your team need onsite Microsoft Excel VBA training courses in Sussex, Kent, Surrey and London, we can help. We offer Excel VBA training courses for all versions with 2016 being the most popular. We often visit clients across the Southeast & would love to train you at your offices to enable your staff are up to speed & are highly competent on Excel VBA. 

The Excel VBA training courses listed below are our structured 3 day sessions. 

If you are further away or would rather do it online, we also offer online excel training courses (UK-wide). Please call us on 01892 665 353 to talk through your business requirements or email us.

Please note: Delegates should have completed and Introductory and Advanced Excel course prior to attending. Alternatively they should have a good working knowledge of the advanced features in Excel.

  • What is a Macro
  • Recording a Macro
  • Running a Macros
  • Relative references
  • The Developer Ribbon
  • Assigning Macros to a button on the Ribbon
  • Assigning Macros to sheet buttons
  • Adding Macros to a ribbon
  • Editing a Macro
  • Procedures
  • Inserting comments
  • Printing a VBA Module
  • Cells method
  • Range method
  • Flexible ranges
  • Virtual worksheets
  • Range contents
  • Controlling objects with properties
  • Performing actions with methods
  • Performing multiple actions
  • Variables
  • Data Types
  • Constants
  • Conditional Control Structures
  • Looping Control Structures
  • Non-structured statements
  • Sub Procedures
  • Built-in dialogue boxes
  • Predefined dialogue boxes
  • Controls
  • Custom dialogue boxes
  • Assigning procedures to a dialogue box
  • Customised menus
  • Managing menus
  • Toolbars
  • Tooltips
  • Types of errors
  • Break mode
  • Instant watch
  • Stepping
  • Creating automatic procedures
  • Creating event procedures
All Oregen Training Onsite Courses

Clare ChaffeyClare Chaffey
12:36 09 Jun 21
Great one day course on MS Project. Basic introduction covered all the fundamentals and friendly teacher with a great teaching style. Would highly recommend.
Alexander LowAlexander Low
13:36 08 Jul 19
I went on an Excel Introductory Course provided by Oregen Computer Training Ltd. It was a small group but actually was just what was needed to get through the workshop. There were enough breaks to allow us to absorb the information which was delivered expertly by our Trainer for the day. The surroundings were quiet and well-suited to the course. I learnt an amazing amount which I have started to put into practice in my business in order to organise my statistics to see how the business is doing very month. I would absolutely recommend Oregen to anyone who wants to start or simply update their software knowledge. Well done to Jo Humphrey for organising and to Oregen Computer Training Ltd for hosting this excellent course. Thank you
helen mulhollandhelen mulholland
11:00 04 Jul 19
Thanks to Oregen Computer Training for a great one day basic Excel course for beginners. Great content delivered in calm quiet environment. Ideal for learning. Easy to get to nearby free parking
katherine mottkatherine mott
10:43 29 Oct 18
Thank you to Oregen Computer Training for a successful and informative training session in Introductory and Intermediate Excel training.
Lucio EstibeiroLucio Estibeiro
14:38 28 Jan 18