On-Site Excel VBA Training Courses

If you or your team need on-site Excel VBA training courses in Sussex, Kent, Surrey and London, we can help. We offer Excel VBA training courses for versions 2003-2016, with 2010, 2013 and 2016 being the most popular. We often visit clients in Croydon, Guildford, Brighton and Crawley and would love to train you at your offices so that all your staff are highly competent on Excel VBA.

The Excel VBA training courses listed below are our structured 3 day sessions.  We also offer 1, 1.5 and 2 hour modular on-site Excel training and bespoke/custom IT training for Excel VBA in Sussex, Kent, Surrey and London that will revolutionise the way your employees operate. 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.

Download this course information as a PDF file

INTRODUCTION

  • What is a Macro
  • Recording a Macro
  • Running a Macros
  • Relative references
  • The Developer Ribbon

ASSIGNING MACROS TO BUTTONS AND OBJECTS

  • Assigning Macros to a button on the Ribbon
  • Assigning Macros to sheet buttons
  • Adding Macros to a ribbon

EDITING MACROS

  • Editing a Macro
  • Procedures
  • Inserting comments
  • Printing a VBA Module

THE RANGE OBJECT

  • Cells method
  • Range method
  • Flexible ranges
  • Virtual worksheets
  • Range contents

OBJECTS, PROPERTIES & METHODS

  • Controlling objects with properties
  • Performing actions with methods
  • Performing multiple actions

VARIABLES AND CONSTANTS

  • Variables
  • Data Types
  • Constants

CONTROL STRUCTURES

  • Conditional Control Structures
  • Looping Control Structures
  • Non-structured statements
  • Sub Procedures

CONTROLS & USERFORMS

  • Built-in dialogue boxes
  • Predefined dialogue boxes
  • Controls
  • Custom dialogue boxes
  • Assigning procedures to a dialogue box

MENUS & TOOLBARS

  • Customised menus
  • Managing menus
  • Toolbars
  • Tooltips

TESTING & DEBUGGING

  • Types of errors
  • Break mode
  • Instant watch
  • Stepping

EVENT TRIGGERED PROCEDURES

  • Creating automatic procedures
  • Creating event procedures

FUNCTION PROCEDURES

ADD-IN APPLICATIONS