Chapters in this book

1. Frontmatter i
2. Contents v
3. Acknowledgments xiii
4. Introduction xv
5. Chapter 1: Excel Macros – A Quick Start in Excel VBA Programming 1
6. Chapter 2: Excel Programming Environment – A Quick Overview of Its Tools and Features 33
7. Chapter 3: Excel VBA Fundamentals – A Quick Reference to Writing VBA Code 67
8. Chapter 4: Excel VBA Procedures – A Quick Guide to Writing Function Procedures 103
9. Chapter 5: Adding Decisions to Excel VBA Programs – A Quick Introduction to Conditional Statements 133
10. Chapter 6: Adding Repeating Actions to Excel VBA Programs – A Quick Introduction to Looping Statements 151
11. Chapter 7: Storing Multiple Values in Excel VBA Programs – A Quick Introduction to Working with Arrays 165
12. Chapter 8: Keeping Track of Multiple Values in Excel VBAPrograms – A Quick Introduction to Creating and Using Collections 185
13. Chapter 9: Excel Tools for Testing and Debugging – A Quick Introduction to Testing VBA Programs 207
14. Index 233