Ability Software Consultants +44 (0)1531 828366
info@officecourseware.com
Instructor with Microsoft Office, OpenOffice and StarOffice training coursewareOfficecourseware.com

Home Titles Costs Contact Us Links

Table of contents from instructor-led training courseware notes. Page numbers are for guidance only and may vary. Courseware notes are formatted for double-sided printing.

Microsoft Word 2003
VBA Developer

  Page

Bookmarks

 1
What are Bookmarks? 1
Defining Bookmarks 1
Using Bookmarks 1
Predefined Bookmarks 2
Selecting a Bookmark in a Macro 3
Exercise 1 3

Fields

 5
What are Fields? 5
Inserting Fields 5
Viewing Field Results or Codes 6
Field Keys 7
Useful Fields 7
Field Switches 9
Exercise 2 10

Document Templates

 11
Introduction 11
Creating and Using Templates 11
Exercise 3 13

Form Fields

 15
Introduction 15
Creating an On-line Form 15
Creating a Form 16
Form Field Options 17
Protecting Forms 19
Save Forms Data Only 20
Printing a Form 20
Macros and Form Fields 20
Example Form Macros 22
Exercise 4 22

Introduction to Macros

 23
What is a Macro? 23
Why Use Macros? 23
Creating a Macro 23
Running a Macro 26
Auto Macros 31
Exercise 5 32
Answer 5 32

Editing Macros

 33
Visual Basic Editor 33
Procedures 35
Inserting Comments 35
Printing a Visual Basic Module 36
Exercise 6 36
Answer 6 36

The Range Object

 37
Working with Range Objects 37
Story 39
Navigating in Word 39
Inserting, Deleting and Editing Text 40
Working with Bookmarks in VBA 41
Basic Text Formatting 42
Exercise 7 44
Answer 7 44

Objects, Properties and Methods

 45
Introduction 45
What are Objects and Collections? 45
What is a Property? 45
What is a Method? 46
Returning an Object 47

Variables and Constants

 49
Variables 49
Data Types 50
Constants 55

Control Structures

 57
Conditional Control Structures 57
Looping Control Structures 60
Performing Multiple Actions on an Object 64
Non-Structured Statements 64
Sub Procedures 64
Exercise 8 66

Controls, Dialog Boxes and User-Defined Forms

 67
Introduction 67
Built-In Dialog Boxes 67
Predefined Dialog Boxes 69
User-Defined Forms 72
Adding Form Controls 72
Form Control Properties 73
Control and Dialog Box Events 73
Displaying and Dismissing a User Form 74
Handling Form Controls 74
Example 76
Exercise 9 76

Storing Information

 77
Document Variables 77
The Windows Registry 78

Debugging and Error trapping

 81
Errors 81
Break Mode 82
Quick Watch 82
Stepping 83
Error Handling 84
Error Handling Example 85

Events

 87
Introduction 87
Document Events 87
OnTime Method 88

Protection

 89

Macro Security

 91
Introduction 91
Setting the Macro Security Level 91
Digital Signatures 92

Appendix A Naming Conventions

 95
User Form Controls 95
Memory Variables 95
 
  Word 2003 Intro
Word 2003 Adv
Word 2003 Dev
Excel 2003 Intro
Excel 2003 Adv
Excel 2003 Dev
PowerPoint 2003
Outlook 2003
Visio 2003
Access 2003 Intro
Access 2003 Adv
FrontPage 2003		  


All trademarks and product names used on this web page are for identification purposes only and are acknowledged as the registered trademarks of their respective owners. Officecourseware.com and Ability Software Consultants do not claim the endorsement of, or to represent, any of the companies whose names or products are presented on this page.