|
Introduction
What
is a Macro?
Recording
a Macro
Running
a Macro
Relative
References
Assigning Macros
to Buttons and Objects
Assigning
a Macro to a Button on a Sheet
Assigning
a Macro to a Drawn Object on a Sheet
Assigning
a Macro to a Button on a Toolbar
Editing Macros
The
Visual Basic Editor
The
Project Explorer
The
Code Window
Procedures
Inserting
Comments
Printing
a Visual Basic Module
The Range Object
The
Cells Property
The
Range Property
Flexible
Ranges
Range
Contents
Workbooks and
Sheets
Activating
a Workbook
Activating
a Worksheet
ThisWorkBook
Objects,
Properties and Methods
Controlling
Objects with their Properties
Performing
Actions with Methods
Performing
Multiple Actions on an Object
Variables
and Constants
Variables
Data
Types
Constants
Control Structures
Conditional
Control Structures
Looping
Control Structures
Non-Structured
Statements
Subprocedures
Controls, Dialogue
Boxes and Forms
Built-In
Dialogue Boxes
Predefined
Dialogue Boxes
Custom
Forms
Worksheet
Forms
User-Defined
Forms
Adding
Form Controls
Form
Control Properties
Control
and Dialogue Box Events
Displaying
and Dismissing a User Form
Handling
Form Controls
Storing Information
The
Windows Registry
Settings
Files
WritePrivateProfileString
Toolbars and
Display
About
Toolbars and Menus
Customised
Toolbars
Display
Debugging
and Error Trapping
Errors
Break
Mode
Instant
Watch
Stepping
Error
Handling
Error
Handling Example
Worksheet
and Workbook Events
Worksheet
Object Events
Function
Procedures
User-Defined
Functions
Add-in Applications
Creating
an Add-In
Converting
an Add-In to a Workbook
How
to Use What You’ve Learnt
|
