| Table of Contents |
 |
Excel VBA Macro Programming |
|
Introduction |
| |
Part I - Programming in Excel VBA |
|
Chapter 1 |
- |
The Basics |
|
Chapter 2 |
- |
Variables, Arrays, Constants, and Data Types |
|
Chapter 3 |
- |
Modules, Functions, and Subroutines |
|
Chapter 4 |
- |
Programming Basics: Decisions and Looping |
|
Chapter 5 |
- |
Strings and Functions and Message Boxes |
|
Chapter 6 |
- |
Operators |
|
Chapter 7 |
- |
Debugging |
|
Chapter 8 |
- |
Errors and the Error Function |
|
Chapter 9 |
- |
Dialogs |
|
Chapter 10 |
- |
Common Dialog Control |
|
Chapter 11 |
- |
Command Bars and Buttons |
| |
Part II - Object Models |
|
Chapter 12 |
- |
The Excel Object Model |
|
Chapter 13 |
- |
The Excel Object Model—Main Objects |
|
Chapter 14 |
- |
Using Excel to Interact with Other Office Programs |
| |
Part III - Advanced Techniques in Excel VBA |
|
Chapter 15 |
- |
Charts and Graphs |
|
Chapter 16 |
- |
Working with Databases |
|
Chapter 17 |
- |
API Calls |
|
Chapter 18 |
- |
Class Modules |
|
Chapter 19 |
- |
Animation |
| |
Part IV - VBA in Action |
|
Chapter 20 |
- |
Converting Labels to Numbers and Numbers to Labels |
|
Chapter 21 |
- |
Transposing a Range of Cells |
|
Chapter 22 |
- |
Adding Formula Details into Comments |
|
Chapter 23 |
- |
Calculating a Range |
|
Chapter 24 |
- |
Reversing a Label |
|
Chapter 25 |
- |
Who Created the Workbook? |
|
Chapter 26 |
- |
Evaluating a Cell |
|
Chapter 27 |
- |
Sorting Worksheets into Alphabetical Order |
|
Chapter 28 |
- |
Replacing Characters in a String |
|
Chapter 29 |
- |
Timed Events |
|
Chapter 30 |
- |
Auto Totaling a Matrix of Numbers |
|
Chapter 31 |
- |
Absolute and Relative Formulas |
|
Chapter 32 |
- |
Coloring Alternate Rows and Columns of the Spreadsheet |
|
Chapter 33 |
- |
Coloring Cells Containing Formulas |
|
Chapter 34 |
- |
Summing Cells by Reference to a Master Cell |
|
Chapter 35 |
- |
Globally Changing a Range of Values |
|
Chapter 36 |
- |
Displaying Hidden Sheets Without a Password |
|
Chapter 37 |
- |
Searching Multiple Sheets and Workbooks |
|
Chapter 38 |
- |
Brighten Up Your Comments |
|
Chapter 39 |
- |
An Alternative to Message Boxes |
|
Chapter 40 |
- |
Working with Shapes |
|
Chapter 41 |
- |
Turning Your VBA Code into an Add-In |
|
Appendix A |
- |
ASCII Character Codes |
|
Index |
|
List of Figures |
|
List of Tables |
