Excel VBA Training Course Outline

VBA courses for all versions of Excel - VBA for Excel 2013, VBA for Excel 2010, VBA for Excel 2007, VBA for Excel 2003 and other versions. Delivered in AberdeenEdinburghStirling,   Dundee,   Angus,   Fife,   GlasgowLondon,   Perth   and most UK locations. Contact us for further details.

Course objectives

This content has been designed for a one-day classroom course. On course completion, students will be able to:

  1. Use Visual Basic for Applications terminology; start Visual Basic Editor; work with object properties, methods and events; execute code by using a button; and use the Object Browser
  2. Manipulate data by declaring variables and procedures of current scope to be used when and where you need them
  3. Use decision structures to perform decision tasks and loop structures to perform repetitive tasks
  4. Add a user form to your project, add controls to it, handle events associated with form controls, and validate data entry on forms
  5. Identify errors in code, use the debugging tools and write error-handling code to trap errors
  6. This course will help students to become proficient application developers by using the features of Microsoft Excel and Visual Basic for Applications.

Excel VBA Training CourseThe course is designed to give experienced Excel users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.  The course is an effective combination of tuition by an experienced instructor together with hands-on exercises to give the trainee the experience of writing code and applying VBA. 

Course contents

Visual Basic Editor
Topic A: Visual Basic for Applications
Topic B: Object programming
Topic C: The Object Browser

Programming basics
Topic A: Data basics
Topic B: Scope of variables
Topic C: Scope of procedures

Control structures
Topic A: Decision structures
Topic B: Loop structures

Custom dialog boxes
Topic A: User forms
Topic B: Events

Debugging and error handling
Topic A: Errors
Topic B: Debugging
Topic C: Error handling