Word VBA
Course
Inhouse
Description
-
Type
Course
-
Level
Advanced
-
Methodology
Inhouse
-
Duration
2 Days
-
Start date
Different dates available
Our Word VBA Introduction is designed for users who know Microsoft Word very well but who have no knowledge of VBA programming. It familiarises users with essential Visual Basic syntax and programming techniques and introduces them to the Microsoft Word object model. By the end of the training, delegates will know how to write VBA macros from scratch; as opposed to relying on the Macro Recorder.
Facilities
Location
Start date
Start date
About this course
Our Word VBA Introduction is designed for users who know Microsoft Word very well but who have no knowledge of VBA programming. It familiarises users with essential Visual Basic syntax and programming techniques and introduces them to the Microsoft Word object model. By the end of the training, delegates will know how to write VBA macros from scratch; as opposed to relying on the Macro Recorder.
Reviews
Subjects
- Word
- Visual Basic training
- IT
- Microsoft Word
- Syntax
- Visual Basic
- Programming
- Ms Word
- Word VBA on-site training
- Word VBA in-house training
- Word VBA training
Course programme
Our Word VBA Introduction is designed for users who know Microsoft Word very well but who have no knowledge of VBA programming. It familiarises users with essential Visual Basic syntax and programming techniques and introduces them to the Microsoft Word object model. By the end of the training, delegates will know how to write VBA macros from scratch; as opposed to relying on the Macro Recorder.
Getting StartedWelcome to Microsoft Word VBA Macro Programming, What is involved in learning Word VBA?, Getting Set Up, The Developer Tab and Macro Security, Recording a Macro, Attaching Macros to the Quick Access Toolbar, Assigning a keyboard shortcut to a macro, Editing a Recorded Macro, The Benefits and Limitations of the Macro Recorder
Writing Macros in the Visual Basic EditorUnderstanding the Project Explorer, Other VBE Windows and Toolbars, Macros and Subroutines, Getting Help on VBA and the Word Object Model, Setting VBE Options, Setting Project Options
Variables and ConstantsDeclaring and Populating Variables, Variable Data Types, String Variables, Number Variables, Date Variables, Declaring Constants, Using Object Variables, Variables Versus With Statements
Subroutines and FunctionsDefining and Calling Subroutines, Defining and Calling Functions, Passing Arguments, Using Optional Arguments, Variable Scope, Using VBA Functions
Conditionals, Loops and ArraysIf Statements, Select Case Statements, For€¦Next Statements, Do€¦Loop Statements, While€¦Wend Statements, Using Array Variables, Working with Dynamic Arrays
The Word Object ModelUnderstanding the Word Object Model, Working with Object Methods, Working with Object Properties, Referring to objects within a collection, Referencing Versus Selection and Activation, Testing for the Existence of an Object, Removing Objects from a Collection
Events, Dialogs and UserFormsOverview of Event Programming, Working with Document Events, Using Built-in Dialogs, Creating a UserForm, Creating UserForm Event-Handlers, Validating User Input
Debugging and Error HandlingSyntax, Compilation, Run-time and Logic Errors, Overview of Debugging Techniques, Stepping through Code, Using Watches to Monitor Code Elements, Using the Immediate, Locals and Call Stack Windows, Common Types of Error, Using On Error GoTo and Resume Statements, Using the Err and Error Functions
Additional information
£900 for one-to-one training
£1,100 for groups of up to 6 people
£1,300 for groups of up to 12 people
Word VBA