Excel 2002 Power Programming With VBA

Details

Author: Walkenbach, John

ISBN: 0-7645-4799-2

Publisher: M&T Books, 2001, 934 pp., List price $49.95 (US)

Includes: CD-ROM

Status: Available

Target Reader: This book is intended for experienced Excel users who want to master VBA.

Comments: This is a revision of the best-selling Excel 2000 Power Programming With VBA, updated for Excel 2002. It includes many new examples, all of which are available on the companion CD-ROM. In addition, the CD-ROM includes an electronic version of the book.

Unlike other VBA books, it also covers spreadsheet application development from a broader perspective. It covers many advanced topics, and includes tons of insider tips and useful examples that cannot be found elsewhere.

NOTE: This book contains a coupon for a free copy of Power Utility Pak.

Preface

Part I: Some Essential Background

Chapter 1: Excel 2002: Where It Came From
Chapter 2: Excel in a Nutshell
Chapter 3: Formula Tricks and Techniques
Chapter 4: Understanding Excel’s Files

Part II: Excel Application Development

Chapter 5: What Is a Spreadsheet Application?
Chapter 6: Essentials of Spreadsheet Application Development

Part III: Understanding Visual Basic for Applications

Chapter 7: Introducing Visual Basic for Applications
Chapter 8: VBA Programming Fundamentals
Chapter 9: Working with VBA Sub Procedures
Chapter 10: Creating Function Procedures
Chapter 11: VBA Programming Examples and Techniques

Part IV: Working With UserForms

Chapter 12: Custom Dialog Box Alternatives
Chapter 13: Introducing UserForms
Chapter 14: UserForm Examples
Chapter 15: Advanced UserForm Techniques

Part V: Advanced Programming Techniques

Chapter 16: Developing Excel Utilities with VBA
Chapter 17: Working With Pivot Tables
Chapter 18: Working With Charts
Chapter 19: Working With Events
Chapter 20: Interacting with Other Applications
Chapter 21: Creating and Using Add-Ins

Part VI: Developing Applications

Chapter 22: Creating Custom Toolbars
Chapter 23: Creating Custom Menus
Chapter 24: Providing Help for Your Applications
Chapter 25: Developing User-Oriented Applications

Part VII: Other Topics

Chapter 26: Compatibility Issues
Chapter 27: Manipulating Files With VBA
Chapter 28: Manipulating Visual Basic Components
Chapter 29: Understanding Class Modules
Chapter 30: Frequently Asked Questions about Excel Programming

Part V: Appendixes

Appendix A: Excel Resources Online
Appendix B: VBA Statements and Functions Reference
Appendix C: VBA Error Codes
Appendix D: ANSI Code Reference
Appendix E: What's On the CD-ROM