This book should be required reading for all developers working with Visual Basic and VBA (Visual Basic for Applications). Written by recognized VB/VBA experts, this book provides detailed coverage of a wide range of specific VBA programming challenges. Learn to write reusable classes, create well-tuned VBA applications, and investigate and document your work. Specific topics include string handling, understanding class modules, creating dynamic data structures, error handling, working with the System Registry, and creating multimedia. The companion CD includes reusable code from the book, plus third-party shareware and demos.
Table of Contents:
1. The Windows Environment
2. Visual Basic Concepts
3. Designing and Creating Programs
4. Program Flow
5. Interacting with the User
6. Testing and Debugging
7. Graphics
8. Procedures, Functions and Forms
9. Arrays
10. Interacting with the System
11. Sequential Files
12. Records and Random Access Files
13. Graphics
14. MDI Forms
15. Appendices