Excel 2007 VBA Programming For Dummies and over one million other books are available for Amazon Kindle. Learn more
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images
Have one to sell? Sell on Amazon

Excel 2007 VBA Programming For Dummies Paperback – February 20, 2007

ISBN-13: 978-0470046746 ISBN-10: 0470046740 Edition: 1st
Buy used
$13.60
Buy new
$21.75
Used & new from other sellers Delivery options vary per offer
59 used & new from $7.22
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$21.75
$9.92 $7.22

There is a newer edition of this item:

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


Hero Quick Promo
Save up to 90% on Textbooks
Rent textbooks, buy textbooks, or get up to 80% back when you sell us your books. Shop Now
$21.75 FREE Shipping on orders over $35. Only 11 left in stock (more on the way). Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

Excel 2007 VBA Programming For Dummies + Excel 2007 Power Programming with VBA + Excel 2007 Bible
Price for all three: $79.59

Buy the selected items together

Editorial Reviews

From the Back Cover

Step-by-step instructions for creating VBA macros

Harness the power of VBA and create custom Excel applications

Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.

Discover how to

  • Grasp essential programming concepts
  • Use the Visual Basic Editor
  • Navigate the new Excel user interface
  • Communicate with your users
  • Deal with errors and bugs

About the Author

John Walkenbach is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak.
NO_CONTENT_IN_FEATURE


Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 388 pages
  • Publisher: For Dummies; 1 edition (February 20, 2007)
  • Language: English
  • ISBN-10: 0470046740
  • ISBN-13: 978-0470046746
  • Product Dimensions: 7.4 x 0.8 x 9.2 inches
  • Shipping Weight: 1.2 pounds (View shipping rates and policies)
  • Average Customer Review: 4.4 out of 5 stars  See all reviews (37 customer reviews)
  • Amazon Best Sellers Rank: #467,919 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

4.4 out of 5 stars

Most Helpful Customer Reviews

37 of 45 people found the following review helpful By John Matlock on March 28, 2007
Format: Paperback
When all is said and done, John Walkenbach only has three things going for him:

One, he really knows what he is talking about. While this is a For Dummies book, and doesn't go down really into the Power Programming (that's another of his books) level, they couldn't have gotten a more knowledgeable person to write it. You can take what he says in the book (or on the books companion web site just in case a typo made it through the editing system) as something handed down on stone tablets.

Second, he really knows how to convey the information he has. I find his writing style to be well laid out, informative, almost a pleasure to read (true pleasure I associate with good Science Fiction, not any computer book).

Third, he really seems to be a nice guy. While I've never met him, the home page on his web site (given at the very beginning of the book) has a has a link - Send e-mail to John Walkenbach. On a couple of occassions, I've had a reason to send him an e-mail asking a question. He's answered promptly, curteously and save me a whole bunch of time.

If you want a quick and rapid introduction to macros or VBA programming (in Excel these are the same thing), something that will get you started, this is an excellent choice. As you become a power user, buy his Power Programming with VBA book, and indeed his other Excel books.
7 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
9 of 10 people found the following review helpful By Mushka on October 12, 2009
Format: Paperback Verified Purchase
I went through this book in a few weeks time. It's a great help for anyone looking to start in VBA for Excel 2007. The projects/examples were very helpful and I've used the ideas to expand on my own to help create some pretty IMO nifty little helpers to my excel sheets. There are surely many other books out there that claim to be good at this or that, but the dummy series puts a special spin on the way they present it that in no way makes you feel like a "Dummy". I recommend this book to anyone starting out or for a semi experienced used who may just want a different perspective on the way to do things in VBA/Excel.
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
4 of 5 people found the following review helpful By Rene J. Davila Cortez on February 14, 2009
Format: Paperback
This book is perfect for the persons that already know quite a bit of Excel and its capabilities, but don't know the programming side of Excel. I will like to add that this book is easy to understand and very user friendly with the practical explanations.
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
1 of 1 people found the following review helpful By Figoliu on May 31, 2012
Format: Paperback
Compared with other tons of REFERENCE book, this book writes very well in both its contents and its logic. It not gives you all the pictures of VBA (actually it is not necessary to have all of them). But it gives you all you need to start programming in excel and help you to get some projects done pretty well. For a starter or intermediate level VBA programmer, this book is prefect. If you wanna do more and more advanced on VBA, you may have two choices, choose another high-level book, or just discard VBA but go for some other programmings.
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
3 of 4 people found the following review helpful By Partha Bhadra on July 11, 2011
Format: Paperback Verified Purchase
This a good book but could have been shorter and with more screen shots to support the lessons. Too many words does not register the basic idea in reader's head. And when it is time to apply the ideas to some specific projects I start to thumb throught index and the pages. Why can't the authors condense their ideas into some straight forward sentences? Authors of technical books should try to keep the readers awaike. I would say that an opportunity has been missed here to make a good book into a great book.Excel 2007 VBA Programming For Dummies
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
1 of 1 people found the following review helpful By Jimmie Beavers on May 17, 2010
Format: Paperback Verified Purchase
Great book. I needed a book to give me a high level, step by step on how to create a macro in Excel to process data that I generate daily. I was tired of spending an hour every day doing the same thing, so I went looking for a book to teach me how to write a macro. The book as very easy to read and follow. It has a lot of examples. I was able to get all the macros that I needed to write, debug, tested in a couple of weeks.
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
1 of 1 people found the following review helpful By Brian H on September 13, 2010
Format: Paperback Verified Purchase
This book is explained in an easy to understand simple format. I have gone from 0 experience with VBA to writing full macros that are rather coplicated at this point. This book got me started on that path. It is not the end all be all of VBA books and there are a lot of resources out there you will need to chase down and learn for more advanced VBA writing skills.
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
1 of 1 people found the following review helpful By Harold Waters on March 6, 2012
Format: Kindle Edition Verified Purchase
I got this as an electronic book from Amazon so I had it the moment I needed it, no waiting for shipping. This is a good book for the casual user of Excel who whats to appear to be a pro. I have seldom ever needed to do anything special with Excel but recently needed to do some fancy stuff. The answers were there in the book. I would recommend this to a friend.
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 2007 VBA Programming For Dummies
This item: Excel 2007 VBA Programming For Dummies
Price: $21.75
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: last resort download