Course Outline - Excel VBA

Course Code: XLVBA6002

The same basic structure of the course applies to all VBA environments, e.g. Excel, Word and Access but each uses objects specific to the application. Please ask if you are interested in Word or Access VBA.

For those new to programming, Visual Basic for Applications is a different environment to Visual Basic - do ask for guidance if you are not sure if this is the course for you.

Duration: Two Days

Pre-requisites:
Knowledge of Visual Basic for Applications (VBA) is not essential to start this course, but it does assume that delegates are using Excel to an Advanced level.

Course Objectives
This course enables trainees to:
1 understand the different methods of creating Visual Basic for Applications (VBA) modules and the basic syntax of VBA statements;
2 use VBA to manipulate Microsoft Excel objects, to perform arithmetic and display a message on the screen using VBA;
3 prompt the user for information and make use of the information received from the user;
4 test and debug VBA code.

Course Outline

Macro Basics
Introducing the VBA environment; What is a macro; Recording, running and editing macros; Assigning macros to a command button, graphics object and tools menu bar; Recording code into an existing macro

Introduction to VBA
Modules; Procedures; Principles and concepts of programming; Data types, variables and constants; Program flow control; Commands and statements; If…Then… Else; Do…Loop, While and Until; For…Next statements

Object-Oriented Programming
Controlling objects and their properties; Object variables; Performing actions with methods; The range object; Activating workbooks and worksheets

Error Handling
Stepping through code; Finding syntax errors; Using Debug.Print; Building error-trapping routines

User Interface Design and Programming
Built-in dialogue boxes; Controls; Inviting and dealing with user inputs; Assigning procedures to a dialogue box

Target Audience

Advanced users of MS Office who want to record, write and edit macros in order to develop applications for their work environment. This two day course will not cover every aspect of the language, but it will enable delegates to make a useful start.

Please note: We can also develop solutions in Excel for you. Please ask for details.