Excel 2010 Power Programming with VBA and over one million other books are available for Amazon Kindle. Learn more

Excel 2010 Power Programming with VBA 1st Edition

148 customer reviews
ISBN-13: 978-0470475355
ISBN-10: 0470475358
Why is ISBN important?
ISBN
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.
Sell yours for a Gift Card
We'll buy it for $8.89
Learn More
Trade in now
Have one to sell? Sell on Amazon
Rent
$20.40
Buy new
$28.38
Amazon Price New from Used from
Kindle
"Please retry"
Paperback, May 10, 2010
"Please retry"
$28.38
$24.98 $16.99
More Buying Choices
50 New from $24.98 38 Used from $16.99

There is a newer edition of this item:

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


InterDesign Brand Store Awareness Textbooks
$28.38 FREE Shipping on orders over $35. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

Excel 2010 Power Programming with VBA + Excel 2010 Bible
Price for both: $55.00

Buy the selected items together

Editorial Reviews

From the Back Cover

Get more from Excel—learn to extend it with VBA

Learn to use Visual Basic for Applications (VBA), and you can expand the already awesome power of Excel 2010. John Walkenbach, aka Mr. Spreadsheet, shows you how to do it in this easy-to-follow guide.

If you're already an experienced Excel user, this book will make you an Excel master. You'll learn a new approach to Excel and the steps involved in developing a new spreadsheet application. You'll also discover how to develop VBA subroutines and functions, use advanced programming techniques, and more. And if you're switching to Excel 2010 from an earlier version, there's a section to get you up to speed on the new features.

No one can teach you more about Excel than Mr. Spreadsheet.

Let Mr. Spreadsheet show you how to:

  • Create powerful Excel apps with VBA

  • Develop user-friendly dialog boxes

  • Enhance Excel with custom worksheet functions

  • Write event-driven VBA code

CD-ROM INCLUDES:

  • More than 300 files used as examples in the book

  • Searchable PDF of the book

See Appendix D for complete system requirements

About the Author

John Walkenbach, arguably the foremost authority on Excel, has written hundreds of articles and created the award-winning Power Utility Pak. His 50-plus books include John Walkenbach's Favorite Excel 2010 Tips & Tricks, Excel 2010 Formulas, and the bestselling Excel Bible, all published by Wiley. Visit his popular Spreadsheet Page at spreadsheetpage.com.
NO_CONTENT_IN_FEATURE


Using the NewChart Event in Excel 2010
Learn more about the NewChart Event, a feature introduced in Excel 2010 [PDF].

Product Details

  • Paperback: 1080 pages
  • Publisher: Wiley; 1 edition (May 10, 2010)
  • Language: English
  • ISBN-10: 0470475358
  • ISBN-13: 978-0470475355
  • Product Dimensions: 7.4 x 2.2 x 9.2 inches
  • Shipping Weight: 3.6 pounds (View shipping rates and policies)
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (148 customer reviews)
  • Amazon Best Sellers Rank: #14,792 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

84 of 86 people found the following review helpful By 1000Books on July 30, 2010
Format: Paperback Verified Purchase
While everyone's starting to learn cooler hipper languages, the reality is that VBA in excel is still pretty darn useful.

If you have absolutely no experience then VBA for dummies is still - to me - one of the better places to start. The book is not as big and intimidating. However, after you've already written a few programs, this book is fantastic. Great step by step instructions. Lots of examples. Advanced sections are great. It will take me some time before this all becomes old hat for me.

If you were looking for something that uses VBA to link to other Microsoft applications. You should be good with this book. It goes into detail on how to interface with outlook, deal with sending emails, interface with Word or PowerPoint.

If you need to learn how to interface with databases, this is not the best choice. But there is no reason to believe it would be in the title or table of contents, so you really can't complain.

Will it replace the all mighty google. No, but as a supplement, it is excellent and a bit more structured. The explanations are far better than what you'd find on-line. There are tons of random helpful tips and history that - if you're nerdy enough to read the whole book rather than just use the table of contents and index to get to the sections you need - are pretty darn wonderful.

Oh, and for people who can't stand the upgrades in the new version of Excel, the author explains that stuff too. One reason to get the newer vs the older version.
4 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
59 of 61 people found the following review helpful By Sigthor on September 30, 2012
Format: Kindle Edition Verified Purchase
I find the book very informative and useful and I feel cheated on

I sadly bought the Kindle version and I feel ripped off, First I pay 4 dollars more for the Kindle version even if that meant me not getting the CD or other side products. I could live with that, at least I got the book right....

But no, the examples in this book are useless as it is not possible to zoom the images with Kindle and most formuals that Spreadsheet goes over are based on those images.

I had before bought the book "Excel The missing Manual" and that was great on Kindle and it was even cheaper for Kindle,
but adding 4 dollars for Kindle version without any side products and horrible quality is a rip off, and Mr. Spreadseet and Amazon should really do something to fix this. Its amazing disrespect to customers. I cant see my self buy a book by Mr. Spreadsheet again or even Amazon just because of this incident, I'll stick to other authors that at least have the decency to not publish books for Kindle version if they cant provide the same quality as the book.

It is incredibly frustrating and i feel so ripped off, you can not see this flaw in the preview so I feel cheated on.

Sad as the book is so good.
14 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
37 of 40 people found the following review helpful By Glenn on November 22, 2010
Format: Paperback Verified Purchase
I tried the Bill Jelen "VBA and Macros" book first but got too frustrated with it. Too much was left "un-said" in that book. So, even though I was forcing myself to learn from it, I decided to get this book too.

WOW! John Walkenbach does a great job of starting at the beginning, giving a very interesting spreadsheet background, and then quickly and concisely plunging you into the VBA world. I have also picked up a lot of non-VBA great Excel tips that I have started using.

Keep in mind, this book still isn't for the timid. It is serious learning and you have to be prepared to learn quick. But, I feel the book does a great job of teaching with just the right amount of detail. It also helps if you think very logical and sequential. If you can't organize your thoughts, you won't be able to program very well.
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
21 of 21 people found the following review helpful By Jean L. Scalzo on December 19, 2010
Format: Paperback Verified Purchase
I was surprised at the quality of the instruction in this book. It seems to be much more informative of Excel's features than books I have read for prior versions of Excel. I always have considered myself an expert in Excel. This book has shown me wrong. There is a multitude of features and functions that I am extremely happy to see excellent instruction for.
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
16 of 18 people found the following review helpful By Wade T Mackey on April 20, 2012
Format: Kindle Edition Verified Purchase
The book is great. I'm getting a lot out of it. But the kindle version does not include acces to the CD content, the graphics are nearly unreadable and longer code examples on the page disapear of the right side of the screen. Broke down and ordered the physical book.
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
11 of 12 people found the following review helpful By Johnny on January 22, 2012
Format: Paperback Verified Purchase
I had used VBA for Excel before, but it was quite informal and I only learned through studying other VBA programs. So I wasn't exactly a beginner, but I wanted a book to help me brush up on my abilities and serve as a reference in the future. Excel 2010 Power Programming with VBA was a perfect fit. Includes plenty of example files that are useful not only for demonstration, but also for borrowing some techniques and ideas for your own needs. I would highly recommend this book to anyone looking to learn how to use VBA. At less than $30 and nearly a thousand pages of quality instruction and examples, it's hard to find a better value.
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
8 of 9 people found the following review helpful By Carolyn Bell on March 11, 2012
Format: Kindle Edition Verified Purchase
The CD with all the sample code is not included if you buy the digital version. Instantly
having the book available on my iPad was great, but I really wish I could get the code on the
CD too.
5 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
13 of 16 people found the following review helpful By Gene on December 27, 2011
Format: Kindle Edition Verified Purchase
Excellent E-book to learn Excel VBA programming! Author is extremely knowledgeable about the subject. Only 2 issues I have some of the images are unreadable and the Publisher does not have the CD content available for download.
4 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

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 2010 Power Programming with VBA
This item: Excel 2010 Power Programming with VBA
Price: $28.38
Ships from and sold by Amazon.com

What Other Items Do Customers Buy After Viewing This Item?

Want to discover more products? Check out this page to see more: beginning excel