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.
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.
- 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.