Microsoft Office VBA
VBA (Visual Basic for Applications) is a simple, yet powerful programming language
which can be used to automate repetitive tasks in any of the Microsoft Office
programs. We can provide your staff with training on three flavours of VBA: Excel,
Access and Word. Bear in mind, however, that VBA is a programming language. This
means that, if you have no experience of coding, in order to learn VBA, you will need
to simultaneously learn the basics of programming.
Excel VBA Programming Access VBA Programming Word VBA Programming
(2 days) (2 days) (2 days)
Overview Overview Overview
This introductory Excel VBA
Training Course shows delegates
how to create and customise
macros and gives them a basic
familiarity with the Visual Basic
for Applications environment.
Best practices are introduced
from the outset and delegates
are encouraged to learn VBA by
understanding its key principles,
rather than simply memorising
syntax.
Audience
Aimed at intermediate and
advanced users of Excel who
wish to write macros to automate
organisational workflows.
Key Topics Covered
• Basics
• Objects, properties and methods
• The Range property
• Charts and drawing
Our Access programming course
concentrates on the creation of
modules. It shows users how to
use Visual Basic for Applications
(VBA) to control and manipulate the
objects and data in their database
solutions.
Audience
This course is designed for
experienced Access users wishing
to use VBA for database application
development.
Our Word VBA Introduction
familiarises users with essential
Visual Basic syntax and
programming techniques and
introduces them to the Microsoft
Word object model. By the end of
the training, delegates will know
how to write VBA macros from
scratch; as opposed to relying on
the Macro Recorder.
Audience
• The Visual Basic Editor Designed for users who know
Microsoft Word very well but
who have no knowledge of VBA
programming.
• VBA Fundamentals Key Topics Covered
Key Topics Covered
• VBA Programming
• Objects and collections
• Programming forms
• Programming reports
• Error handling
• Getting Started
• Writing Macros in the Visual Basic
Editor
• Variables and Constants
• Subroutines and Functions
• Debugging
• Conditionals, Loops and Arrays
• Using Visual Basic • The Word Object Model
• Making decisions • Events, Dialogs and UserForms
• Interactivity • Debugging and Error Handling
- 18 -
G Com Solutions Limited
0800 998 9248
www.gcomsolutions.co.uk