Word VBA

Course Length: Two Days
Fees: Training at Client Offices: One delegate: £595 per-day + VAT
Additional delegates attending: £150 each per-day + VAT

Manuals available @ £35 each (optional)

Overview: On completion of this course delegates should be able to:

	To create and use custom functions and sub procedures within modules
	To create event procedures in form and report modules and be aware of the scope of event procedures
	To debug code and be able to add error-handling features to their code

This course assumes delegates have an advanced working knowledge of Microsoft Word including creating macros.

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 Forms and Controls

	Working with the Combo Box Control
	Working with the Frame Control
	Working with Option Button Controls
	Working with Control Appearance
	Setting the Tab Order
	Populating a Control

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

If you have other questions, please contact us at enquiry@it-uk.com or complete our response form