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 |