Training Program Details
Basic Macro Concepts
Macros And Sub Procedures
Limitations Of Recorded Macros
Recording Macros
Relative Referencing
Macro Options
Storing Macros
Editing A Macro
Debugging A Macro
Step Into, Step Over, Step Out
Run To Cursor
Seven Ways To Run A Macro; Adding To Toolbars, Creating Buttons, Etc.
Visual Basic
Defining Projects, Modules, Sub Procedures, Statements, And Events
The Visual Basic Editor
Views And Icons
Adding Comments
Checking Syntax Errors
Sub Procedures
Structures Of Sub Procedures
Objects
Working With
Object Names
Class
Properties
Common Properties
Using The With Command
Properties That Are Objects
Methods
Common Methods
Events
The Object Browser
Project/Library Box
Classes
Variables
Constants
Variable Types
String Variables
Date Variables
Declaring Several Variables
User Interaction
Input Boxes
Converting Input Box Answers
Message Boxes
Building Messages
Special Characters To Sue When Concatenating
Message Box For Input
Status Bar Messages
Flow Of Control
If Then Statements
If Then Elseif
Running Other Procedures From Within Procedures
If Statements With Message Boxes
For Next Loops
Do While Loops
Event Trapping
Auto_Open And Auto_Close
On Error Go To
Resume
Application Event Properties
Other Objects Event Properties
Working With Other Programs
Opening / Sending Commands To
Linking Up With Libraries
