|
Introduction
The
Nature and Uses of the VBA Language
How
Projects Relate to Documents
The
Components you can Include in a Project
Where
Code is Stored
Code
in Microsoft Excel
Code
in PowerPoint
Code
in Microsoft Word
Types
of Procedures
Record
Code in Excel, Word and PowerPoint
Use
the Visual Basic Editor to View, Modify and Run Code
Run
Mode and Design Mode
Assign
Code to a Menu or a Command Button on a Toolbar
The
Automatic Help Facility
Macros and
Variables
Create
and Invoke Sub and Function Procedures
Enter
Code
Insert
Comments into the Code
Print
a Visual Basic Module
Use
Variables
Declare
Variables
Scope
of Variables
Lifetime
of Variables
Determine
the Appropriate Data Type to use in a Particular Scenario
Naming
Conventions
Declare
and Use Constants
Procedures
Objects, Properties
and
Methods
What
are Objects?
Object
Properties and Methods
Use
Methods to Perform Actions
Perform
Multiple Actions on an Object
Use
Object Variables
Declare
an Object Variable
Set
an Object Variable
Determine
whether an Object Variable is Set
Explore
Properties
The Object
Library
The
Hierarchy of Objects
Control
an Object Model
Reference
an Object Library
Use
the Object Browser to View an Object Model
Objects
VBA
Programming
Control Structures
If
... Then ... Else Statement
Select
Case Statement
Do
...
Loop
Statement
Control
Structures
Error
Trapping
and Debugging
Types
of Errors
Error
Handling
Set
an Error Trap
Debug
Break
Mode
The
Immediate Window
The
Locals Window
The
Watch Window
The
Call Stack
Error
Handling
The
Office
Assistant
Assistant
Object Model
Modify
the Assistant
Assistant
Balloons
Display
a Balloon
Office
Assistant
Menus
and Toolbars
Command
Bars
Overview
Manually
Customise a Command Bar
Command Bars
Object Model
Show
and Hide a Command Bar
Add
Controls to a Command Bar
Create
a New Command Bar
Create
a Toolbar
Add
Advanced Controls
Create
a Command Bar
How
to Use What You’ve Learnt
|
