Industrial-Sized Deals TextBTS15 Shop Women's Handbags Learn more nav_sap_SWP_6M_fly_beacon Beach House Fire TV Stick Subscribe & Save Shop Popular Services tmnt tmnt tmnt  Amazon Echo Starting at $99 Kindle Voyage AutoRip in CDs & Vinyl Shop Back to School with Amazon Back to School with Amazon Outdoor Recreation Deal of the Day
Excel 2003 Power Programming with VBA and over one million other books are available for Amazon Kindle. Learn more

Excel 2003 Power Programming with VBA (Book & CD-ROM) 1st Edition

57 customer reviews
ISBN-13: 978-0764540721
ISBN-10: 0764540726
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used
Buy new
More Buying Choices
24 New from $7.98 54 Used from $0.01
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

InterDesign Brand Store Awareness Textbooks
$39.26 FREE Shipping. Only 19 left in stock (more on the way). Ships from and sold by Gift-wrap available.

Frequently Bought Together

Excel 2003 Power Programming with VBA (Book & CD-ROM) + Excel 2003 Bible + Excel 2003 Formulas
Price for all three: $95.40

Buy the selected items together

Editorial Reviews

From the Back Cover

"Today, no accomplished Excel programmer can afford to be without John’s book. The value of Excel 2003 Power Programming with VBA is double most other books–simultaneously the premier reference and best learning tool for Excel VBA."
—Loren Abdulezer, Author of Excel Best Practices for Business

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.

CD-ROM Includes

  • Trial version of the author’s award-winning Power Utility Pak
  • Over one hundred example Excel workbooks from the book

System Requirements: PC running Windows® 2000 SP3 or later, or Windows XP™ or later. Microsoft Excel 2003. See the "What’s on the CD" Appendix for details and complete system requirements.

About the Author

John Walkenbach, principal of JWalk and Associates Inc., is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 30 spreadsheet books and more than 300 articles and reviews for publications including PC World, InfoWorld, and Windows, and maintains the popular Spreadsheet Page at


Best Books of the Month
Best Books of the Month
Want to know our Editors' picks for the best books of the month? Browse Best Books of the Month, featuring our favorite new books in more than a dozen categories.

Product Details

  • Paperback: 1056 pages
  • Publisher: Wiley; 1 edition (January 13, 2004)
  • Language: English
  • ISBN-10: 0764540726
  • ISBN-13: 978-0764540721
  • Product Dimensions: 7.5 x 2.1 x 9.3 inches
  • Shipping Weight: 3.4 pounds (View shipping rates and policies)
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (57 customer reviews)
  • Amazon Best Sellers Rank: #839,818 in Books (See Top 100 in Books)

More About the Author

John Walkenbach, a.k.a. Mr. Spreadsheet, is arguably the world's foremost authority on Microsoft Excel. His fifty-plus Excel books include Excel 2013 Power Programming with VBA, Excel 2013 Formulas, and the bestselling Excel 2013 Bible, all published by Wiley. He has also written hundreds of articles and software reviews, and created the award-winning Power Utility Pak add-in for Excel.

John lives in Tucson, Arizona. He also plays the banjo - but don't let that prevent you from buying his books.

Customer Reviews

Most Helpful Customer Reviews

273 of 276 people found the following review helpful By William A. Huber on February 11, 2004
Format: Paperback
Needing to finish my first Excel add-in, and frustrated by the incompleteness and obscurity of MS's help system, I picked up this book after reading warm recommendations from readers of earlier versions.
If you have never programmed Excel before, but have programmed a tiny bit in some other language, and do not have great ambitions for software development, this might be a fine text. It is quite readable and full of useful information. Walkenbach introduces VBA quickly, which is great, but so quickly he forgets to say what most of the language constructs do. His approach to teaching the Excel object model is to provide several fairly well written examples of little macros and utilities, each one with a clear English explanation. Unfortunately, if the technique you need does not appear in any of these examples, you are out of luck, because his explanations are neither extensive, detailed, nor thorough enough to impart a good understanding of what is going on. This, coupled with Excel's erratic behavior (mis-type a property name and watch your user form mysteriously disappear, for instance), makes it very difficult to become independently productive without spilling a lot of sweat and tears.
The book's strengths include the numerous and well-organized examples provided on the companion CD; the occasional sidebar that offers first-hand knowledge of bugs, inconsistencies, and strange design; fairly broad, if incomplete, coverage of the major aspects of Excel VBA programming; and very clear indications of differences among various Excel versions (97, 2000, 2003 mainly). Walkenbach is obviously an expert and has been so for a long time.
The weaknesses become apparent in contrasting this book with, say, Roman's text (O'Reilley).
Read more ›
2 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
130 of 140 people found the following review helpful By Eric Green on April 10, 2005
Format: Paperback
I first heard of John Walkenbach this past summer. I work for a large Financial Services firm in New York City, and our employees use his Excel Add-in extensively. I purchased his book on Power Programming VBA in an effort to learn how to program Excel, and, now, I feel duty-bound, to give you some feedback.

It was early January of this year (2005) when I purchased "Excel 2003 Power Programming". At first I was skeptical. The book arrived, 1000 pages thick, and I do not like wordy books, but having heard of his reputation, I began, what became, a spell-binding read. So intrigued was I by his clear, insightful, and sprightly method in reaching the heart of VBA and its practical Excel uses, that I went back to Amazon and purchased two of his other books: "Excel 2003 Formulas" and "Excel Charts". I have almost completed them, too, and I am reeling with amazement at this man's work and knowledge!

Firstly, the author is one terrific writer who arouses your interest and is able to convey Excel's object structure and its related programming concepts in a way that few others can (especially, if you are new to programming). The writing balance is perfect: not too wordy, not too concise. Secondly, the author's possesses a world-class knowledge of Excel and how to make full use of it. (As I understand, Dr. Walkenbach has written 30 books over the last decade on Excel alone!). Thirdly, the author offers you many superb practical examples - page after page. This greatly aids your understanding and inspires your imagination. Fourthly, the book is packed with Excel tips and tricks that will, sometimes, fascinate you or humble you if you considered yourself an Excel expert. (This is even more applicable to his book on Excel Formulas).
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
49 of 51 people found the following review helpful By Amazon Customer on December 15, 2004
Format: Paperback
This is a great book for those that are

-Advanced Excel users, but Beginner / Intermediate with VBA

-Programmers that are picking up VBA (Me)

Not for

-Basic Excel users

-Advanced VBA programmers

General Outline

The author steps through the basics of spreadsheets and spreadsheet applications before introducing VBA, and does well covering most of the aspects of Excel.

Good - This is a weighty tome, coming in at over 1,000 pages, and is an overall excellent reference to those that are starting to use VBA.

- Contains excellent overview of using VBA with Excel, with extensive coverage of userforms and all their controls, and actual programming.

- Gets deep into Excel specific features like charts and pivot tables

- Excellent coverage of the differences (and possible problems) with different versions of Excel.

- FAQ and Appendixes that are actually helpful and provide useful information

Bad - Not too much to really pick on here, but I generally dislike books that are filled with some extraneous information, just to get that "Ultimate Reference" look about them. The chapter "Excel 2003:Where it came From", and the sometimes overly inflated explanations seemed liked padding. But otherwise a GREAT book.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
41 of 42 people found the following review helpful By Amazon Customer on March 9, 2005
Format: Paperback Verified Purchase
I was very disappointed in the book. I have written some macros in VBA for excel and wanted to expand my knowledge while creating some useful macros for my company.

If one was intending to read this book front to back, I am sure they could learn quite a lot about Excel and VBA, but as for using it as a tool to expand on existing knowledge and/or as a falls short.

Most of the examples did some neat things, but trying to build upon them to fit a specific need indicated just how limited the explanation of how the examples work are.

I often ran across things in the examples that I would later find a use for, but then be unable to locate them since they were buried in some seeming unrelated portion of the book, and the index was just about useless.

If you want to start learning VBA or if the examples in the book do what you need then this may be the book for you, but if you are expecting to build upon the examples and/or use them as a reference for writing your own custom macros/tools, I would suggest looking elsewhere.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Excel 2003 Power Programming with VBA (Book & CD-ROM)
This item: Excel 2003 Power Programming with VBA (Book & CD-ROM)
Price: $39.26
Ships from and sold by

What Other Items Do Customers Buy After Viewing This Item?

Want to discover more products? Check out these pages to see more: mobile app, vba, microsoft excel, advanced excel