Word Programming with VBA
Course
In Cardiff
Description
-
Type
Course
-
Location
Cardiff (Wales)
-
Duration
2 Days
This course is designed to provide delegates with the skills necessary to take advantage of the powerful facilities offered by Visual Basic for Applications (VBA) to enhance and automate their Word documents and templates.
Facilities
Location
Start date
Start date
About this course
Before attending this course, students must have: Previous knowledge of Word 2003 or Word 2000.
Reviews
Course programme
Overview
This course is designed to provide delegates with the skills necessary to take advantage of the powerful facilities offered by Visual Basic for Applications (VBA) to enhance and automate their Word documents and templates.
Examination information
There is no examination associated with this course.
Prerequisites
Before attending this course, students must have:
Previous knowledge of Word 2003 or Word 2000.
Course outline
Getting Started
Introducing Visual Basic for Applications
Recording a Macro
Running a Macro
Editing a Macro in the Visual Basic Editor
Understanding the Desktop
Using the Menu Bar
Using the Toolbar
Using the Project Explorer
Introducing the Properties Window
Using the Code Window
Getting Help
Closing the Visual Basic Editor
Introducing Objects
Understanding Objects
Exploring the Word Object Model
Using the Object Browser
Working with the Document Object
Working with the Selection Object
Writing VBA Code
Working with the Code Window
Understanding Expressions and Statements
Declaring and Using Variables
Understanding Data Types
Working with the Input Box
Using Intrinsic Constants
Using the Message Box
Using the With Statement
Working with Forms and Controls
Understanding UserForms
Using the Toolbox
Working with UserForm Properties, Events, and Methods
Using the Properties Window
Understanding Controls
Working with the Label Control
Working with the Text Box Control
Working with the Command Button Control
Working with the Combo Box Control
Working with the Frame Control
Working with Option Button Controls
Working with Procedures, Functions, and Control Structures
Understanding Sub Procedures and Functions
Creating Functions
Calling Procedures and Functions
Using Intrinsic Functions
Understanding Program Control Structures
Working with the Select Case Structure
Working with Conditional Expressions
Working with the If...Then...Else Structure
Working with Looping Structures
Using Debugging Tools and Handling Errors
Using the Immediate Window
Using the Step and Break Tools
Understanding Error Handling
Using the On Error Statement
Writing an Error Handling Routine
Executing Macros
Assigning a Macro to a Shortcut Key
Assigning a Macro to a Custom Menu or Toolbar
Modifying an Existing Word Command
Creating an Automatic Macro
Word Programming with VBA