We use cookies to offer you a better experience and to analyse how visitors use our site, you may consent to our cookies by continuing to use our site, or you may view more information and choose to reject cookies by clicking here. Thank you

Contact us online or call us on 0191 377 8377

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields
Course VBA using Word
  • Course Duration2 Days
  • Course Options
    Private
    Private
    Flexible content, flexible date, flexible location, variable 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.
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
Prerequisites
    • Delegates should have attended Word Level 1, Level 2 and Level 3 or have equivalent knowledge.
Objectives
    • Automate many kinds of operations in macros. As well as utility macros (Opening, Saving, Printing, Proofing etc..), the application of VBA to all types of Word Documents will be covered.
What's included
    • Comprehensive course materials and exercises
    • Telephone and Email Support
    • Laptops are available for training delivered at client's premises
    • 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

 

Course Dates Please contact us to discuss dates for this course, thank you

 

IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk

Printed: 23 Feb 19

 

 

 

Contact us

  • Name*:*
  • Organisation:
  • Telephone:
  • Email:*
  • Message*:*
  • Send me a copy of this email
  • Send me course updates from time to time via email

    Your subscription will naturally terminate after your chosen time limit. We will get in touch just before the end so that you can subscribe again if you would like to continue receiving information after that point.

* Required Fields