Course
VBA using Word
Private Courses
This course is available as a private event. A private event can be held at one of our venues, your location, or somewhere else if you prefer.
Course Duration
2 Days 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
- Lunch and refreshments when training is delivered at our training venues
Course Content
-
KEY TOPICS
-
Day 1VBA 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 2Word 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
You can choose your learning path and delivery style. Courses can be delivered at your office or at one of our training venues, it's your choice. Small class sizes. Course materials included. Flexible course content. Expert trainers and tried & tested training methods. 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.
-
Course Options
Please contact us to discuss options for this coursePrivatePrivateFlexible 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.BespokeBespokeBespoke 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 Training
IT Training Solutions Ltd
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:3/19/2024 5:11:14 AM
Oakville, 14 Durham Road West, Bowburn, Durham, DH6 5AU
0191 377 8377
ittrainingsolutions.co.uk
Printed:3/19/2024 5:11:14 AM