Excel VBA Training Course

Excel VBA Training Course Outline

VBA courses for all versions of Excel - VBA for Excel 2019, 365, 2016, 2013, 2010 and other versions. Delivered in Dundee,   Aberdeen,  Edinburgh,  Stirling,   Angus,   Fife,   Glasgow,  London,   Perth and most locations across the country. 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.

The 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
Visual Basic for Applications
Object programming
The Object Browser

Programming basics
Data basics
Scope of variables
Scope of procedures

Control structures
Decision structures
Loop structures

Custom dialog boxes
User forms
Events

Debugging and error handling
Errors
Debugging
Error handling