Index

Chapters in this book

1. Frontmatter i
2. Contents v
3. Acknowledgments xi
4. Introduction xiii
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 (VBE) 37
7. Chapter 3 Excel VBA Fundamentals: A Quick Reference to Writing VBA Code 73
8. Chapter 4 Excel VBA Procedures: A Quick Guide to Writing Function Procedures 111
9. Chapter 5 Adding Decisions to Excel VBA Programs: A Quick Introduction to Conditional Statements 143
10. Chapter 6 Adding Repeating Actions to Excel VBA Programs: A Quick Introduction to Looping Statements 163
11. Chapter 7 Storing Multiple Values in Excel VBA Programs: A Quick Introduction to Working with Arrays 179
12. Chapter 8 Keeping Track of Multiple Values in Excel VBA Programs: A Quick Introduction to Creating and Using Collections 199
13. Chapter 9 Excel Tools for Testing and Debugging: A Quick Introduction to Testing VBA Programs 221
14. Index 253