Detailed information
| Type: | Training |
|---|---|
| Method: | In a classroom |
| Accreditation: | vtl Certificate |
| Prepares for: | At the end of this course you will be able to: Appreciate the benefits of using Visual Basic (VBA) macros. Record, run and edit basic Word macros. Interpret and edit VBA code. Apply programming techniques such as conditional branching and loops to your macros. Acquisit user data and display messages. Create User Forms to manage complex user input. |
| Geared towards: | This course has been developed for advanced Word users who need to automate document handling using Word Visual Basic for Applications (VBA). |
| Requirements: | Competence with Microsoft Windows. Familiarity with many of the features covered on the Introductory and Advanced Word courses. |
Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course program
Word Templates
Overview of the uses of document Templates and the features that are stored within them.
Creating and editing Templates, and copying features from one Template to another.
Creating Forms
An introduction to creating and editing forms as a means of controlling the positioning and contents of entries made to standard layout documents.
VBA (Macro) Basics
Recording simple Macros to automate routines such as document formatting.
Using convenient ways of running Macros - toolbars, buttons within documents, shortcut keys.
Editing VBA Program Code
An introduction to the programming behind recorded Macros.
Understanding the syntax of the code and making simple changes.
Using the VBA Help system.
Extending Control
Introducing some commonly used commands to give more power and flexibility to your Macros, such as making the actions of your Macro conditional on some activity.
Creating non-recordable code for:
Toggling settings.
Managing user-input and displaying messages.
Declaring and using variables.
Use of conditional statements.
Looping and using sub-routines.
User Forms
Creating and utilising custom User Forms to manage user interaction.
Processing data returned from user forms.
Additional Topics
Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.
Overview of the uses of document Templates and the features that are stored within them.
Creating and editing Templates, and copying features from one Template to another.
Creating Forms
An introduction to creating and editing forms as a means of controlling the positioning and contents of entries made to standard layout documents.
VBA (Macro) Basics
Recording simple Macros to automate routines such as document formatting.
Using convenient ways of running Macros - toolbars, buttons within documents, shortcut keys.
Editing VBA Program Code
An introduction to the programming behind recorded Macros.
Understanding the syntax of the code and making simple changes.
Using the VBA Help system.
Extending Control
Introducing some commonly used commands to give more power and flexibility to your Macros, such as making the actions of your Macro conditional on some activity.
Creating non-recordable code for:
Toggling settings.
Managing user-input and displaying messages.
Declaring and using variables.
Use of conditional statements.
Looping and using sub-routines.
User Forms
Creating and utilising custom User Forms to manage user interaction.
Processing data returned from user forms.
Additional Topics
Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.
Do you need clarification regarding the course program?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Vantage Training Limited
vtl are a specialist software training and application development company providing your total office solution. Our training can be tailored to your needs and our development team can provide you with time saving solutions to simplify and speed up your tasks at work. We formed as a limited company in 1995, have offices in Nottingham and Cheshire and deliver our services nationwide.
Our aim is to help you make the most of your software – whether this is through providing your staff with the skills they need to utilise programs, or through working with you to develop bespoke applications. We don’t see these as two distinct options, but more a continuum that our services can travel along. Because of our customisation, we are able to offer you what ever level of support you need – from standard classroom training, through workshop style sessions that can solve your problems on specific projects, to building applications for you with your design input. We even design and deliver courses on your existing bespoke software packages.
Our aim is to help you make the most of your software – whether this is through providing your staff with the skills they need to utilise programs, or through working with you to develop bespoke applications. We don’t see these as two distinct options, but more a continuum that our services can travel along. Because of our customisation, we are able to offer you what ever level of support you need – from standard classroom training, through workshop style sessions that can solve your problems on specific projects, to building applications for you with your design input. We even design and deliver courses on your existing bespoke software packages.
Search similar to Office Systems
- Courses IT, ICT and Computing
- Courses PC Applications
- Courses Office Systems
- IT Training
- Access Training Nottingham
- IT Training Nottingham
- Software Training Nottingham
- Computer Training Nottingham
- Access Database
- Database Training Nottingham
- Database Design
- ICT Training Nottingham
- Courses Vantage Training Limited
