Details
Author: Walkenbach, John
ISBN: 1-56884-642-8
Publisher: IDG Books Worldwide, 1996, 378 pp., $24.95 (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. Of all the books I've written, this was the most enjoyable. Think of it as a less intense version of my Excel For Windows 95 Power Programming With VBA . But don't let the title fool you. This book contains lots of great techniques.
More:
- Can't find the coupon for your free copy of Power Utility Pak? Click here for details.
- View the errata sheet for this book.
Table of Contents
Introduction
Part I: Introducing VBA
- Chapter 1. What is VBA?
- Chapter 2. Jumping Right In
Part II: How VBA Works With Excel
- Chapter 3. All About VBA Modules
- 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. Some 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. 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. When Excel's Normal Menus Aren't Good Enough
- Chapter 20. Customizing the Excel Toolbars
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: Advanced Stuff
- Chapter 24. Using the Windows API
- Chapter 25. Automating Tasks That Use Lists
- Chapter 26. Other Useful VBA Techniques
Part VIII: The Part of Tens
- Chapter 27. Top-10 VBA Tips and Tricks
- Chapter 28. Top-10 VBA Questions (and Answers)
- Chapter 29. Top-10 Signs That You Purchased a Bad Spreadsheet
- Chapter 30. Top-10 Excel Resources