Excel 2003 Power Programming with VBA

  • 14h
  • John Walkenbach
  • John Wiley & Sons (US)
  • 2004

Everything you need to know about:

  • Creating stellar UserForms and custom dialog box alternatives
  • Working with VBA subprocedures and function procedures
  • Incorporating event-handling and interactions with other applications
  • Building user-friendly toolbars, menus, and help systems
  • Manipulating files and Visual Basic components
  • Understanding class modules
  • Managing compatibility issues

Feel the power of VBA and Excel

No one can uncover Excel’s hidden capabilities like "Mr. Spreadsheet" himself. John Walkenbach begins this power user’s guide with a conceptual overview, an analysis of Excel application development, and a complete introduction to VBA. Then, he shows you how to customize Excel UserForms, develop new utilities, use VBA with charts and pivot tables, create event-handling applications, and much more. If you’re fairly new to Excel programming, here’s the foundation you need. If you’re already a VBA veteran, you can start mining a rich lode of programming ideas right away.

About the Author

John Walkenbach is a leading authority on spreadsheet software and is principal of JWalk and Associates Inc., a small San Diego-based consulting firm that specializes in spreadsheet application development. John is the author of more than 30 spreadsheet books and has written more than 300 articles and reviews for a variety of publications, including PC World, InfoWorld, Windows, and PC/Computing. He also maintains The Spreadsheet Page, a popular Internet Web site, and is the developer of Power Utility Pak, an award-winning add-in for Microsoft Excel. John graduated from the University of Missouri and earned a masters degree and a Ph.D. from the University of Montana.

In this Book

  • Excel 2003: Where It Came From
  • Excel in a Nutshell
  • Formula Tricks and Techniques
  • Understanding Excel's Files
  • What is a Spreadsheet Application?
  • Essentials of Spreadsheet Application Development
  • Introducing Visual Basic for Applications
  • VBA Programming Fundamentals
  • Working with VBA Sub Procedures
  • Creating Function Procedures
  • VBA Programming Examples and Techniques
  • Custom Dialog Box Alternatives
  • Introducing UserForms
  • Userform Examples
  • Advanced UserForm Techniques
  • Developing Excel Utilities with VBA
  • Working with Pivot Tables
  • Working with Charts
  • Understanding Excel's Events
  • Interacting with Other Applications
  • Creating and Using Add-Ins
  • Creating Custom Toolbars
  • Creating Custom Menus
  • Providing Help for Your Applications
  • Developing User-Oriented Applications
  • Compatibility Issues
  • Manipulating Files with VBA
  • Manipulating Visual Basic Components
  • Understanding Class Modules
  • Frequently Asked Questions about Excel Programming