Overview:
This course takes the user beyond recording a basic macro and introduces the power of VBA, the programming language behind Word. You will be learning basic programming fundamentals, but this is a non-technical course, suitable for Word users at any level.
Objectives:
On completion of this course attendees will be able to:
- Insert and manage a variety of Word fields, including form fields;
- Record and playback macros;
- Add macros to command buttons and shortcuts;
- Understand VBA syntax fundamentals;
- Use Objects, Properties, Methods, and Decision Structures;
- Interface with the user via input and message boxes;
- Declare Variables;
- Perform programme looping and debugging.
Pre-Requisites:
Attendees should have the working knowledge of Word and have a requirement to automate this work.
Course Curriculum
| Getting Started | |||
| Introducing Visual Basic for Applications Details | 00:00:00 | ||
| Recording a macro Details | 00:00:00 | ||
| Running a macro Details | 00:00:00 | ||
| Editing a macro in the Visual Basic editor Details | 00:00:00 | ||
| Understanding the development environment Details | 00:00:00 | ||
| Using Visual Basic help Details | 00:00:00 | ||
| Closing the Visual Basic editor Details | 00:00:00 | ||
| Working with Bookmarks and Fields | |||
| Defining and using bookmarks Details | 00:00:00 | ||
| Predefined bookmarks Details | 00:00:00 | ||
| Selecting a bookmark in a macro Details | 00:00:00 | ||
| Inserting fields Details | 00:00:00 | ||
| Viewing field results or codes Details | 00:00:00 | ||
| Field keys: useful fields Details | 00:00:00 | ||
| Field switches Details | 00:00:00 | ||
| Working with Procedures and Functions | |||
| Understanding modules Details | 00:00:00 | ||
| Creating a standard module Details | 00:00:00 | ||
| Creating a sub procedure Details | 00:00:00 | ||
| Calling procedures Details | 00:00:00 | ||
| Naming procedures Details | 00:00:00 | ||
| Working with the code editor Details | 00:00:00 | ||
| Using Expressions, Variables and Intrinsic Functions | |||
| Understanding expressions and statements Details | 00:00:00 | ||
| Declaring variables Details | 00:00:00 | ||
| Understanding data types Details | 00:00:00 | ||
| Working with variable scope Details | 00:00:00 | ||
| Understanding constants Details | 00:00:00 | ||
| Using intrinsic constants Details | 00:00:00 | ||
| Using message boxes Details | 00:00:00 | ||
| Using input boxes Details | 00:00:00 | ||
| Understanding Objects | |||
| Understanding objects Details | 00:00:00 | ||
| Navigating the Word object hierarchy Details | 00:00:00 | ||
| Understanding collections Details | 00:00:00 | ||
| Using the object browser Details | 00:00:00 | ||
| Working with properties Details | 00:00:00 | ||
| Using the with statement Details | 00:00:00 | ||
| Working with methods Details | 00:00:00 | ||
| Declaring and using object variables Details | 00:00:00 | ||
| Controlling Program Execution | |||
| Understanding control-of-flow structures Details | 00:00:00 | ||
| Using the if…end if decision structures Details | 00:00:00 | ||
| Using the select case…end select structure Details | 00:00:00 | ||
| Using the Do…Loop structure Details | 00:00:00 | ||
| Using the For…Next structure Details | 00:00:00 | ||
| Using the For Each…Next structure Details | 00:00:00 | ||
| In-Line Forms | |||
| Creating an on-line form Details | 00:00:00 | ||
| Creating a form: form field options Details | 00:00:00 | ||
| Protecting forms: save forms data only Details | 00:00:00 | ||
| Printing a form Details | 00:00:00 | ||
| Macros and form fields Details | 00:00:00 | ||
| User Forms and Controls | |||
| Creating User Forms Details | 00:00:00 | ||
| Using the toolbox Details | 00:00:00 | ||
| Working with User Form properties, events and methods Details | 00:00:00 | ||
| Understanding controls Details | 00:00:00 | ||
| Setting control properties in the properties window Details | 00:00:00 | ||
| Debugging Code | |||
| Understanding errors Details | 00:00:00 | ||
| Using debugging tools Details | 00:00:00 | ||
| Setting breakpoints Details | 00:00:00 | ||
| Stepping through code Details | 00:00:00 | ||
| Using break mode during run mode Details | 00:00:00 | ||
| Determining the value of expressions Details | 00:00:00 | ||
Course Reviews
No Reviews found for this course.
0 STUDENTS ENROLLED