Order this book from amazon.com
Details
Author: John Walkenbach
ISBN: 0764505661
Publisher: IDG Books Worldwide, 1999, 382 pp., List price $24.99 (US)
Status: Available
Target Reader: This book is intended for experienced Excel users who want to get more out of the product.
Comments: This is a light-hearted guide to learning VBA programming. Despite the title, you'll find lots of useful information, tips, and techniques.
Table of Contents
Part I: Introducing VBA
- Chapter 1. What is VBA? (Click here to read the chapter)
- Chapter 2. Jumping Right In
Part II: How VBA Works With Excel
- Chapter 3. Introducing the Visual Basic Editor
- Chapter 4. Introducing Excel's Object Model
- Chapter 5. VBA Subroutines and Functions
- Chapter 6. Using the Excel Macro Recorder
Part III: Programming Concepts
- Chapter 7. Essential VBA Language Elements
- Chapter 8. Working With Range Objects
- Chapter 9. Using VBA Functions and Excel Functions
- Chapter 10. Controlling Program Flow and Making Decisions
- Chapter 11. Automatic Procedures and Events
- Chapter 12. Error-Handling Techniques
- Chapter 13. Bug Extermination Techniques
- Chapter 14. VBA Programming Examples
Part IV: Developing Custom Dialog Boxes
- Chapter 15. Custom Dialog Box Alternatives
- Chapter 16. Custom Dialog Box Basics
- Chapter 17. Using Dialog Box Controls
- Chapter 18. Dialog Boxes Techniques and Tricks
Part V: Creating Custom Menus and Toolbars
- Chapter 19. Customizing the Excel Toolbars
- Chapter 20. When Excel's Normal Menus Aren't Good Enough
Part VI: Putting It All Together
- Chapter 21. Creating Worksheet Functions - And Living to Tell About It
- Chapter 22. Creating Excel Add-Ins
- Chapter 23. Creating Excel Applications for Other Users
Part VII: The Part of Tens
- Chapter 24. Top Ten VBA Tips and Tricks
- Chapter 25. Top Ten VBA Questions (and Answers)
- Chapter 36. Top Ten Excel Resources