fbpx

Word VBA

Microsoft Word VBA On-Site Training Sessions

If you or your team need on-site Word VBA training courses in Sussex, Kent, Surrey and London, our support and specialists can help. We offer Word VBA training courses for versions 2003-2013, with 2007, 2010 and 2013 being the most popular. We often visit clients in Croydon, Guildford, Brighton and Crawley and can to train you at your offices so that all your staff are highly competent and productive on Word VBA.

The Word VBA training courses listed below are our structured 1 day sessions.  We also offer 1, 1.5 and 2 hour modular on-site Word training and bespoke/custom IT training for Microsoft Word in Sussex, Kent, Surrey and London that will revolutionise the way your employees operate. Please call us on 01892 665 353 to talk through your business requirements or email us about our Microsoft Word VBA training sessions.

Download this course information as a PDF file

Delegates should have completed and Introductory and Advanced Word course prior to attending. Alternatively they should have a good working knowledge of the advanced features in Word.

AN INTRODUCTION TO MACROS

  • Recording a Macro
  • Running a Macros
  • Relative references
  • The Developer Ribbon

ASSIGNING MACROS TO BUTTONS AND OBJECTS

  • Assigning Macros to buttons
  • Adding Macros to an existing Ribbon
  • Creating a New Tab and Group

USING THE INTEGRATED DEVELOPMENT ENVIRONMENT (IDE)

  • Correctly use the Project Explorer to locate Class or Standard Modules.
  • Use the Properties Pane to change object properties.
  • Use the Code Window to write your procedures.

DISCOVERING WORD OBJECTS

  • Understand how to reference the components of the Word application; documents, sentences, words, characters.
  • Browse Word Objects in the Word Object Library.

WORKING WITH METHODS AND PROPERTIES

  • Change aspects of objects by correctly assigning Properties.
  • Manipulate the behaviour of objects by correctly assigning Methods

CREATING USER FORMS

  • Create a User Form to show information to users.
  • Create a User Form to automatically insert user information into in a document.

CONSTRUCTING CODE

  • Use “If Then”, “If Then Else” and “If Then ElseIf” decision structures in your procedures.
  • Use Variables to hold values to be used by the procedure.
  • Use Select Case statements for complex decision structures.
  • Use For…Next…Loops to execute code repeatedly until conditionally stopped.
  • Use On Error statements to control errors in your code.
  • Step through your code to find bugs.

USING THE MSGBOX FUNCTION

  • Display user messages that respond to user actions.
  • Display user messages to prompt the user for an action e.g. “Yes/No” Message Boxes.

USING THE INPUTBOX FUNCTION

  • Collect user information to which the procedure can respond.

RESPONDING TO EVENTS

  • Write procedures to respond to the Open and Close events.

USING STANDARD MODULES

  • Use Standard Modules to store standard procedures.
  • Call procedures from Standard Modules.

About Oregen Training

The go to supplier for effective IT training solutions.

For over 25 years we have been providing quality instructor led IT training to the corporate and small business market place ...

- read more

Contact Information

Telephone: 01892 665353
07484 546338

Email: info@oregentraining.com

Sister Company – IT SUPPORT, SERVICES & INSTALLATION EXPERTS