Microsoft Excel - VBA

Course Summary

A hands-on instructor-led Microsoft Excel VBA training course helping people wanting to improve existing Excel skills to program Excel through VBA to achieve what they need. The course is designed to give delegates an initial overview of programming within the Excel environment, enabling them to automate and improve the functionality of their Excel spreadsheets. This level of programming capability with Excel is achieved by learning, discussion and practice working together with a master-class level trainer in a professional classroom environment.

One Day Course

Course Aims

Learning to work with VBA involves understanding object properties, methods, and events. Trainees will become able to manipulate data by declaring variables with procedures of correct scope to be used when and where these are needed. Training therefore covers:

• Using decision structures to perform decision tasks

• Using loop structures to perform repetitive tasks

• Adding a user form to your project for consistency and control

Course Content

Introduction to Excel VBA

• Reasons for using VBA rather than Macros

• Understanding the Development Environment

• The Visual Basic Editor, Parts of the Screen

• Code colours, Using Visual Basic Help Procedures and Functions

• Modules, Procedures

• Creating a Sub Procedure

• Call Sub Procedures

• Creating and Use Function Procedures Objects, Properties and Methods

• Understanding Classes and Objects

• Navigating the Excel Object Hierarchy

• Understanding Collections

• Using the Object Browser

• Working with the Application Object

• Using Properties and Methods

• Using the With Statement

• Working with Events

• Order of Events