Microsoft Word VBA Training

Vantage Training Ltd (vtl)
4.2
45 reviews
  • The course content was extremely helpful and we were mainly correcting issues and understanding regular mistakes. Do please pass on our thanks again to the tutor, Gill, she is a great trainer and we would be interested in further VBA courses in the future.
    ← | →
  • We were a small group and it was good I think because it allowed the trainer to answer questions quite effectively, I liked everything about the course and would higly recommend it.
    ← | →
  • Excellent trainer and explained things very well.
    ← | →

Short course

In Timperley and Nottingham

£ 190 + VAT

The best Word courses

See all

See all

Description

  • Type

    Short course

  • Level

    Advanced

  • Location

    At 2 venues

  • Duration

    1 Day

  • Start date

    Different dates available

This course has been developed for advanced Word users who need to automate document handling using Word Visual Basic for Applications (VBA).

Facilities

Location

Start date

Nottingham (Nottinghamshire)
The Wharf, Trent Lane, East Bridgford,, NG13 8PF

Start date

On request
Nottingham (Nottinghamshire)
The Wharf, Trent Lane, East Bridgford,, NG13 8PF

Start date

Different dates availableEnrolment now open
Timperley (Cheshire)
See map
Canal Road, WA14 1TD

Start date

Different dates availableEnrolment now open

About this course

What will I expect to achieve at the end of the training?
At the end of this course
you will be able to:

Appreciate the benefits of using Visual Basic (VBA) macros.
Record, run and edit basic Word macros.
Interpret and edit VBA code.
Apply programming techniques such as conditional branching and loops to your macros.
Acquisit user data and display messages.
Create User Forms to manage complex user input.

This course has been developed for advanced Word users who need to automate document handling using Word Visual Basic for Applications (VBA).

What do I need to know before attending?

Competence with Microsoft Windows. Familiarity with many of the features covered on the Introductory and Advanced Word courses.

vtl attendance certificate

Vantage Training Ltd courses, are designed focusing on getting the best out of Word, interactive hand-on training – with practical exercises. We have been delivering high quality training to our customers for over 20 years. All course delegates are given a mouse-mat, pen and course manual to take away…plus 30 days post training support by telephone or email.

After enquiring about our IT courses, we will email you with the relevant course outline, course prices and date options. After agreeing a mutually convenient course date, we will send you a course booking form. When you have completed and returned your course booking form, we will send you your course joining instructions as confirmation of your booking.
After the course we will ring or email you to check that you are happy with your course and then send you your invoice, which is due within 30 day payment term.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.2
fantastic
  • The course content was extremely helpful and we were mainly correcting issues and understanding regular mistakes. Do please pass on our thanks again to the tutor, Gill, she is a great trainer and we would be interested in further VBA courses in the future.
    ← | →
  • We were a small group and it was good I think because it allowed the trainer to answer questions quite effectively, I liked everything about the course and would higly recommend it.
    ← | →
  • Excellent trainer and explained things very well.
    ← | →
100%
4.4
fantastic

Course rating

Recommended

Centre rating

Lola Dale

0.0
14/04/2017
What I would highlight: The course content was extremely helpful and we were mainly correcting issues and understanding regular mistakes. Do please pass on our thanks again to the tutor, Gill, she is a great trainer and we would be interested in further VBA courses in the future.
Would you recommend this course?: Yes

Former Student

0.0
06/04/2017
What I would highlight: We were a small group and it was good I think because it allowed the trainer to answer questions quite effectively, I liked everything about the course and would higly recommend it.
Would you recommend this course?: Yes

Former Student

5.0
02/03/2017
What I would highlight: Excellent trainer and explained things very well.
Would you recommend this course?: Yes

Caitlin Aneja

4.5
02/03/2017
What I would highlight: I took the Word course with Vantage Training. Plenty of opportunity to ask lots of questions - they were all answered fully and competently. Also a kind and enthusiastic trainer!
Would you recommend this course?: Yes

Former Student

4.5
07/12/2016
What I would highlight: A very comprehensive course on how to use Word. I enjoyed learning new information and being able to practice my learning on the computer.
Would you recommend this course?: Yes
See all
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 15 years

Subjects

  • Ms Word
  • Microsoft Word
  • Word Documents
  • Word
  • Code debugging and testing
  • Word Processing
  • Visual Basic
  • VBA Training
  • Microsoft Word VBA Training
  • Word VBA course

Teachers and trainers (1)

Gill Lewis

Gill Lewis

Technical Trainer

20+ years experience of training delivery. Manages a team of trainers and application developers with similar skills. Extensive programming experience using Microsoft Office based applications usually requiring Visual Basic programming. Designed, managed, and delivered corporate training roll-outs for several companies, including Astra Zenica, and Unilever. Responsible for initial training needs analysis, training delivery, through to effective evaluation and post training support. Providing training solutions for a variety of industries, public sector, and educational establishments.

Course programme

Content

Word Templates
Overview of the uses of document Templates and the features that are stored within them.
Creating and editing Templates, and copying features from one Template to another.

Creating Forms
An introduction to creating and editing forms as a means of controlling the positioning and contents of entries made to standard layout documents.

VBA (Macro) Basics
Recording simple Macros to automate routines such as document formatting.
Using convenient ways of running Macros - toolbars, buttons within documents, shortcut keys.

Editing VBA Program Code
An introduction to the programming behind recorded Macros.
Understanding the syntax of the code and making simple changes.
Using the VBA Help system.

Extending Control
Introducing some commonly used commands to give more power and flexibility to your Macros, such as making the actions of your Macro conditional on some activity.
Creating non-recordable code for:
Toggling settings.
Managing user-input and displaying messages.
Declaring and using variables.
Use of conditional statements.
Looping and using sub-routines.

User Forms
Creating and utilising custom User Forms to manage user interaction.
Processing data returned from user forms.

Additional Topics
Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.

See related categories

Microsoft Word VBA Training

£ 190 + VAT

The best Word courses

See all

See all