- Paperback: 1104 pages
- Publisher: Wiley; 1 edition (April 1, 2013)
- Language: English
- ISBN-10: 1118490398
- ISBN-13: 978-1118490396
- Product Dimensions: 7.4 x 2 x 9.3 inches
- Shipping Weight: 3.5 pounds (View shipping rates and policies)
- Average Customer Review: 139 customer reviews
- Amazon Best Sellers Rank: #30,366 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Excel 2013 Power Programming with VBA 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Frequently bought together
Customers who bought this item also bought
Customers who viewed this item also viewed
From the Back Cover
Learn to extend Excel 2013 with VBA programming
Whether your job or your curiosity impels you to learn how to develop programs that automate and enhance Excel, you'll find no better teacher than John Walkenbach. This book provides a complete introduction to Visual Basic for Applications and shows you exactly how to create the custom dialog boxes known as UserForms. Then it takes you into advanced programming techniques, such as developing utilities and using VBA to work with PivotTables and charts.
You'll also learn to create user-oriented applications, modify shortcut menus, and provide online help for your applications. If you know your way around Excel and are ready to take your skills to the next level, this book is for you.
Let Mr. Spreadsheet show you how to:
- Develop VBA subroutines and functions
- Create custom UserForms and dialog boxes
- Use VBA to create add-ins, PivotTables, and charts
- Create procedures that execute automatically when events occur
- Work with class modules and color
About the Author
John Walkenbach, arguably the foremost authority on Excel, has written 50+ books, including multiple editions of the bestselling Excel Bible and Excel Formulas, as well as more than 300 articles for publications such as PC World, InfoWorld, and Windows. He created the award-winning Power Utility Pak and provides Excel information and insight at www.spreadsheetpage.com.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
1. The book enables "New to VBA and even new to Excel" users to ramp up to proficiency quickly.
2. The book is laid out in a reference book manner so that if you need to go after a specific item you can do so quickly.
3. Despite serving as a primer at several levels, the book serves as an in depth explanation text as well; e.g. , events, user forms, etc.
Using this reference I was able to construct my first VBA macros and from there design and implement now daily used VBA applications that automate our processes. Using what I learned from Excel VBA I was able to dive into PowerPoint VBA which, while different, shares many similarities with Excel VBA. Our level of effort for daily reporting has dropped from three hours to less than an hour using these programs and it all started with this reference book.
1) Yes, you should read each chapter at least skimming the material. I am a certified Microsoft 2013 Expert and I still found new details that I wasn't aware of during my initial read. The book covers the Excel program's features - not just the VBA aspect. Again making this a great reference for anyone looking to take advantage of all that Excel can offer.
2) I have had minimal experience as a programmer. I had eight months of C++ programming training last used 13 years ago when I was a Senior in High School. I also tried out some Java programming for a few months but never went anywhere with it. The point: Anyone can learn this as long as you put in the time to understand the material. It helps to have a program in mind and then try to build it. My first editions of my now daily used programs were terrible. They crashed all the time, had unexpected results, but I learned to handle all of these a little bit at a time.
3) Get the hard copy. You can take a hard copy with you anywhere and make notes on the pages if need be. Or place bookmarks easily. I have a reference manual on Kindle for KML Programming and I really didn't like it at all.
This is exceptionally well written and clearly explains the changes in VBA in Excel 2013 (there are some extensive differences in the new version of Excel 2013), for which I needed a reference to help explain them (which this book does) (Please note that I use VBA a lot for my work, especially in Excel so take my statement as easy to read and explain based on my experience!)
There are numerous examples found on the book website, thus explaining the lack of CD (or DVD) that accompanied the past books in this series. Don't hesitate to partake of the offerings... it is helpful in a lot of the examples to actually see the spreadsheet being discussed while reading about it.
Most recent customer reviews
I would like to learn Excel VBA to be able to develop applications. So I am planning to use this book and learn all of its content over the next 6 months.Read more