Word Programming with VBA

Course

In Cardiff

£ 400 + VAT

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

Cardiff
See map
East Moors Road, CF24 5RR

Start date

On request

About this course

Before attending this course, students must have: Previous knowledge of Word 2003 or Word 2000.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

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

£ 400 + VAT