VBA using Word

     

Private courses can be held at your site or one of our training venues, and can be customised to fit your requirements.

You can choose to have a private course based on an existing outline or you can choose the most applicable lessons from a number of different outlines and consolidate them into one course.

We can also write bespoke courses to fit your specific requirements, whether you require training on a standard application or a bespoke inhouse system.

Please contact us to discuss this further on 0191 377 8377.

Recording a macro

Running a macro
Using tools, macro command
Using a macro button field

Assigning macros

Assigning it to a menu and toolbar
Assigning it to the shortcut keys

The visual basic editor

The menu bar and toolbars
The project explorer
The properties window

Program statement syntax

Objects
Properties and methods

Using Word constants

Declaring variables
The Dim statement
Working with specific data types
Using variables

Visual Basic Functions

InputBox function
MsgBox function

Object variables Building formulas

Using operator precedence

Writing conditional expressions

If....then
Testing several conditions
Using logical operators

Select case

Using comparison operators
For....next
For....each
Using with notation
Do loops

Using built in dialog boxes

Displaying dialog tabs
Setting dialog box options

User Forms

Displaying a form
Changing the properties of a control
Programming a form
Writing event procedures

Creating auto macros

Automating templates and macros
Creating a template
Saving a template
Creating an automatic macro

Training Options

What's Included