Macro Basics
What is a Macro?
Recording & Running a Macro
The Visual Basic Editor
Project Explorer Views
Viewing Object Code
Macro Layout
Comments
Sub procedures
Statements
The Visual Basic Toolbar
Relative vs Absolute Recording
Differences in code
Macro Playback Variations
Shortcut Keys
Shortcut Key Conflicts
Command Buttons
Custom Toolbars/Menus
Assigning Custom Toolbars
Attaching Toolbars
Macro Creation Techniques
Working With Modules
Keyboard Movement Keys
The Procedure List
Add, Remove, and Rename
Writing Macro Code
Understanding VB Statements.
Case Sensitivity
Getting Help on Visual Basic code
User Defined Functions
Function Structure
Creating Your Own Functions
Syntax & Constants
Decision Making Macro Code
If ... Then ... Else
Select Case
Loops
For...Next loop
Do... Loops
For...Each...Next Loops
Simplifying Data Entry Code
Creating Variables
Variables That Store Objects
Variables That Store Values
Rules for Naming Variables
|
Interactive Macros
Macros That Talk!
Message Boxes
Forcing Line Breaks in Code
A Simple Message Box
Visual Basic Help While Typing
Warning or Choice Boxes
The Buttons Argument
Naming Arguments
Responding to Message Box
Input Boxes
Using the Chr() function
Add-Ins
Creating Add-Ins
Debugging
Language Errors
Run-Time Errors
Logical Errors
Debugging Tools
Breakpoints
The Debug Toolbar
Step Into, Over and Out
The Watch Window
Final Thoughts
Appendix A: Introduction to User Forms
User Forms
Insert the User Form
Add, Size & Position Controls
Size and Position Controls
Name the Controls
Test the User Form
Tab Index
Write The General Code
Writing Code for Controls
Procedure Calls
Appendix
Creating Automatic Macros
Object Events
|