Values Macro Basics
What is a Macro?
Recording a Macro
Running a Macro
The Visual Basic Window
Project Explorer Views
Macro Layout
Macro Comments
Sub procedures
Statements
The Visual Basic Toolbar
Relative vs Absolute Recording
Observing the differences in code
Macro Playback Variations
Shortcut Keys
Shortcut Key Conflicts
Command Buttons
Custom Toolbars/Menus
Custom Toolbars to Workbooks
Macro Creation Techniques
Working With Modules
Keyboard Movement Keys
Add, Remove & Rename Modules
Writing Macro Code
Understanding Visual Basic Statements
Getting Help on Visual Basic code
User Defined Functions
Function Structure
Creating Your Own Functions
A Word About Syntax
Using Constants
Decision Making Macro Code
If ... Then ... Else
Select Case
Loops
For...Next, Do..., For...Each...Next
Creating Variables
Variables That Store Objects
Variables That Store
|
Select Vs. Activate
A Note on Our Example Macros
Worksheet Functions in Macro Code
Interactive Macros
Macros That Talk!
Message Boxes
A Simple Message Box
Named Arguments
Warning or Choice Message Boxes
The Buttons Argument
Responding to The Message Box
Input Boxes
Using the Chr() function
User Forms
Insert the User Form
Add and Position Controls
Size and Position Controls
Name the Controls
Test Form for Usability & Set Properties
Tab Index
Write Code To Be Used For the Form
Writing Code for User Form Controls
Procedure Calls
Debugging
Language Errors
Run-Time Errors
Logical Errors
Debugging Tools
Breakpoints
The Debug Toolbar
Step Into Step Over and Step Out
The Watch Window
Add-Ins
Creating Add-Ins
Activating An Add-In at Startup
|