Training Course

VBA using Word

PDF
2 Days

Course Overview

This course is designed to help experienced Word users automate common tasks and create end user systems. The user does not have to be a programmer to benefit from this course but any programming experience will be of value

Course Prerequisites

    • Delegates should have attended Word Level 1, Level 2 and Level 3 or have equivalent knowledge.

Included with this course

    • Comprehensive course materials and exercises
    • Telephone and Email Support
    • Lunch and refreshments when training is delivered at our training venues

Course Content

  • KEY TOPICS

  • Day 1

    VBA Projects, Modules and Procedures - structure and coding
    VBA Development Environment and Help
    Recording Macros
    Running macros - Keys, Buttons, Events and Menus
    Variables and Constants - Declaration, assignment & scope
    Calling procedures and passing parameters
    Showing message boxes and reading button presses
    Reading use input via INPUTBOX
    Flow of Control commands (IF, SELECT, FOR, DO, WHILE etc.)

  • Day 2

    Word Object hierarchy - Documents, Paragraphs, Range & Selection
    Setting Application Properties
    Document management and Properties
    Paragraph Properties and Methods
    Creating your own User Forms for use in templates
    Adding controls to the User Form
    Coding in the User Form
    Completing documents from the UserForm
    Automating one application from another
    Creating and amending Command Bars and Toolbars
    Debugging Macros, Breaks, Watches & Run Time errors
    Triggering Macros from Events

 

Private Training

Flexible dates, location and content. All prices exclude VAT.

  • Private Courses

    Flexible dates, location and content. All prices exclude VAT.
  • Call us on
    0191 377 8377
    to discuss your requirements.
    Mon-Fri 9am-5pm.
    Ask a Question
    Keep me up to date with offers and news
    By submitting this form, you consent to IT Training Solutions Ltd storing your information in order to respond to your request.
  • VBA using Word Course Options
    Private
    Private
    Flexible course content, flexible training date(s), flexible location(s), variable course length, private to your organisation - Courses can be held at one of our training venues or at another location convenient to you. Training can be set over a number of days or weeks to allow for practice time between training sessions.
    Bespoke
    Bespoke
    Bespoke private training can be based on an existing course or a number of lessons taken from several courses, we can also write bespoke courses for you based on your in-house systems or development program.
    Virtual
    Virtual
    These courses can be attended from anywhere.
  • Virtual Training

 

Course Reviews
What were the most useful aspects of the course "The one to one undivided attention to areas I needed to improve."

M.B. MGL Group, Telephone Skills

"All of the course gave me a wide insight into Excel and its capabilities."

M.W. Litterboss Ground Control, Excel Level 1

"Good trainer and very clued up on subject"

H.G. Vantec, Excel Analysing and Presenting Data with Dashboards and Pivot Tables

"[The trainer] was super patient, kept going over areas and answered all our weird and wonderful questions."

S.P. Impact International, Excel Level 2

Following this training what are you going to do differently "Create my own metrics. Analyse statistics"

J.C. CMR UK Ltd, Excel Level 3

Which part of the course did you find particularly valuable "I found all of the course valuable. Although I do use Excel on a daily basis I wasn't aware of some of the shortcuts that were shown to us today and these will certainly benefit me goung forward"

C.P. , Excel Level 2

"Very well presented course and lots of very useful pointers on how to do things."

G.O. Lighthouse Poole, Excel Level 2

Following this training what are you going to do differently "I made a lot of notes based on the useful tips [the trainer] shared, it will certainly assist with improving sharing schedules with clients, especially where client driven delays are experienced."

L.A. Tekmar, Microsoft Project Essentials

 

Private Courses

Flexible dates, location and content. All prices exclude VAT.

 

Please contact us to discuss your VBA using Word course, we have many solutions available to ensure you receive the best training possible.
Your VBA for Word course can be delivered online or in-person.  You can choose your learning path and delivery style.  Learn in-person or online with our virtual classrooms.  Your course can be delivered online, at your office or at one of our training venues, it's your choice. Small course sizes. Course materials included. Flexible VBA using Word course content. Expert trainers and tried & tested training methods. Many course materials available online using your personal training account.  You can master VBA for Word, please contact us to book a place or request a quote for your VBA using Word course.
Microsoft Word and Visual Basic for Applications are registered trademarks of the Microsoft Corporation Visual Basic for Applications (VBA) using Word training courses in North East England including Newcastle, Washington and Durham
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:6/18/2025 7:09:27 PM