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