Programming Books C Java PHP Python Learn more Browse Programming Books
Excel VBA Programming For Dummies and over one million other books are available for Amazon Kindle. Learn more

Sorry, this item is not available in
Image not available for
Color:
Image not available

To view this video download Flash Player

 


or
Sign in to turn on 1-Click ordering
Sell Us Your Item
For a $7.80 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Start reading Excel VBA Programming For Dummies on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Excel VBA Programming For Dummies [Paperback]

John Walkenbach
4.7 out of 5 stars  See all reviews (27 customer reviews)

List Price: $29.99
Price: $17.84 & FREE Shipping on orders over $35. Details
You Save: $12.15 (41%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
Want it Monday, July 14? Choose One-Day Shipping at checkout. Details
Free Two-Day Shipping for College Students with Amazon Student

Formats

Amazon Price New from Used from
Kindle Edition $16.49  
Paperback $17.84  
Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

Book Description

February 15, 2013 1118490371 978-1118490372 3

Take control of your spreadsheets and use VBA to create your own custom Excel applications

Author and Excel guru John Walkenbach, known to his devoted fans as "Mr. Spreadsheet," guides you through taking your Excel skills to the next level by creating your own customized spreadsheet solutions using Visual Basic for Applications (VBA). This updated edition of this bestselling book shows you how to use VBA, write macros, customize your Excel apps to look and work the way you want, avoid errors, and more.

  • Introduces you to a wide array of new Excel 2013 options, beginning with the most important tools and operations for the Visual Basic Editor
  • Provides an overview of the essential elements and concepts for programming with Excel, including using VBA to customize your applications and automate functions
  • Shares techniques for handling errors, debugging, working with range objects, controlling flow, and much more
  • Zeroes in on creating custom dialog boxes, toolbars, and menus

Add a personal touch to your spreadsheets and present your data the way you want with Excel VBA Programming For Dummies, 3rd Edition.


Frequently Bought Together

Excel VBA Programming For Dummies + Excel 2010 Power Programming with VBA + 101 Ready-To-Use Excel Macros
Price for all three: $71.65

Buy the selected items together


Editorial Reviews

From the Back Cover

Learn to:

  • Use the essential tools and operations for VBA
  • Get the most out of Excel's macro recording feature
  • Handle errors and eliminate bugs in your code
  • Develop custom worksheet functions and user-oriented applications

Explore VBA programming and learn how to customize and automate many aspects of Excel

Maybe you're eager to learn Excel programming. Maybe it's your boss's idea. Either way, this book will have you on your way to Excel programming perfection in no time! It's a plain-English guide to what VBA is, how it works with Excel, essential programming concepts, and steps to creating some very cool dialog boxes, time-saving macros, Excel add-ins, and more.

  • VBA-speak — learn the language of VBA and steps for creating a program in Excel
  • Macro magic — automate common tasks, create custom buttons and commands, and develop new worksheet functions using VBA macros
  • Programming basics — work with range objects, control program flow, automate procedures and events, and exterminate bugs in your code
  • User communication — explore simple and custom dialog boxes and UserForm controls, tricks, and techniques
  • All together now — apply your skills to design user-oriented applications, create add-ins, and work with other Office applications

Open the book and find:

  • Some Excel history that's good to know
  • All about VBA sub and function procedures
  • How you can get ahead by learning VBA
  • The difference between programming errors and runtime errors
  • Tips for finding and fixing bugs
  • How to customize Excel's user interface
  • Ways to super-charge your formulas with custom worksheet functions
  • VBA dos and don'ts

About the Author

John Walkenbach, known to his fans as Mr. Spreadsheet, has written some 50 books and around 300 articles on computer topics, predominantly Excel. He created the award-winning Power Utility Pak and several other versatile Excel add-ons. John maintains the Spreadsheet Page at http://spreadsheetpage.com.


Product Details

  • Paperback: 408 pages
  • Publisher: For Dummies; 3 edition (February 15, 2013)
  • Language: English
  • ISBN-10: 1118490371
  • ISBN-13: 978-1118490372
  • Product Dimensions: 9.3 x 7.4 x 0.9 inches
  • Shipping Weight: 1.2 pounds (View shipping rates and policies)
  • Average Customer Review: 4.7 out of 5 stars  See all reviews (27 customer reviews)
  • Amazon Best Sellers Rank: #4,904 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
12 of 13 people found the following review helpful
5.0 out of 5 stars Great Resource April 9, 2013
Format:Paperback|Verified Purchase
Pros:
Easy to read.
Great for beginners.
Easy to navigate (table of contents/index easy to understand).
Cons:
It is good for beginners, for the more advanced processes it is not all that helpful.
Dumbs it down alot and makes it seem somewhat childish for people who already understand how excel/VBA work.

Overall, it is a good product. I was hoping it would be more in depth but it will get the job done. It gives you the basic tools you need to code in excel VBA, and helps the user understand how it all works.
Comment | 
Was this review helpful to you?
8 of 8 people found the following review helpful
4.0 out of 5 stars Exactly what the description says October 9, 2013
Format:Paperback|Verified Purchase
This is your typical "dummies" book.
Written at a level for even the most novice person.
I would recommend this book if you were looking to begin your VBA knowledge base.
Comment | 
Was this review helpful to you?
6 of 6 people found the following review helpful
5.0 out of 5 stars VBA programming success - finally June 17, 2013
Format:Paperback|Verified Purchase
Over the years I have tried many books to help me to learn how to write VBA programs. I have made the most progress with this book. After reading only a few Chapters, I was able to write a few basic programs that solved a few longstanding problems in some of my spreadsheets.
Comment | 
Was this review helpful to you?
6 of 6 people found the following review helpful
5.0 out of 5 stars Great book! June 12, 2013
Format:Paperback|Verified Purchase
This book is very easy to understand ... I am about a 1/3 of the way through. I wanted a book for beginners, so this worked. I plan to get another book that is more advanced when I am finished with this one so I can continue to learn.
Comment | 
Was this review helpful to you?
4 of 4 people found the following review helpful
5.0 out of 5 stars Wonderful beginner book April 4, 2013
Format:Kindle Edition|Verified Purchase
This book is clear and concise. It was well written for a beginner or as a review. I highly recommend this book.
Comment | 
Was this review helpful to you?
3 of 3 people found the following review helpful
5.0 out of 5 stars Excellent January 28, 2014
Format:Paperback|Verified Purchase
This book has been a much needed crutch and lends very helpful hints and useful code. Very happy with the purchase.
Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
3.0 out of 5 stars Underwhelmed March 30, 2014
By Tanie
Format:Paperback|Verified Purchase
I know this was supposed to be more conceptual but I didn't leave this book feeling like I could code up solutions to my problems, I left it feeling like I needed to buy another book to learn how to apply the concepts explored here.
Comment | 
Was this review helpful to you?
2 of 2 people found the following review helpful
5.0 out of 5 stars Great start! February 13, 2014
Format:Kindle Edition|Verified Purchase
Great book!
This book is so advanced and simple as it promises. For a beginner is the best way to start.
Comment | 
Was this review helpful to you?
Most Recent Customer Reviews
5.0 out of 5 stars Five Stars
great product fast delivery
Published 1 day ago by guy dillon
5.0 out of 5 stars Perfect for my purposes
Walkenbach is an excellent author. He brought me back into programming with hundreds of relevant examples and an easy-going approach to learning.
Published 19 days ago by William J. Freeman
5.0 out of 5 stars Its a book
This helps you learn what you need to, buy it, read it, practice it and you are golden. Enough said.
Published 25 days ago by shelly meyer
5.0 out of 5 stars excellent introduction book about VBA
It is an excellent book on Excel VBA introduction, especially for those without prior programming experience. Read more
Published 1 month ago by Amazon Customer
5.0 out of 5 stars perfect for my needs at the time
As usual, Walkenbach hits it out of the park. If you've never used VBA and need to learn the basics, this is a very good place to start. Read more
Published 1 month ago by Peter Johnson
4.0 out of 5 stars Practical
I found the book friendly and practical. It is very well written , in a tone that is both personal and informative.
Published 1 month ago by Lior Alk
5.0 out of 5 stars excellent resource for vba beginners
Very precise, easy to read and understand. Definitely a good resource to learn vba.

I will definitely go for the formulas book
Published 3 months ago by add
5.0 out of 5 stars Great Book
I was a beginner and wanted to know more about VBA, this was well worth the money and would recommend it to anyone who wants to get more familiar with VBA! Read more
Published 3 months ago by bradyj87
5.0 out of 5 stars wonderful read
The book is an introduction to VBA programming, however what I have learned after reading it has been so useful in my every day work that I feel "empowered". Read more
Published 3 months ago by Ruben Torres
5.0 out of 5 stars Perfect Starting Point
Wow, I wanted to get started with VBA, and I bought this book along with reading everything I can on the web. This is very well written, not only informative, but Mr. Read more
Published 5 months ago by Kevin Carter
Search Customer Reviews
Search these reviews only

What Other Items Do Customers Buy After Viewing This Item?


Forums

There are no discussions about this product yet.
Be the first to discuss this product with the community.
Start a new discussion
Topic:
First post:
Prompts for sign-in
 



Look for Similar Items by Category


Want to discover more products? You may find many from microsoft 365 help shopping list.