Start reading Excel VBA Programming For Dummies on your Kindle in under a minute. Don't have a Kindle? Get your Kindle here or start reading now with a free Kindle Reading App.
OR
Read for free
with Kindle Unlimited

Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

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

Excel VBA Programming For Dummies [Kindle Edition]

John Walkenbach
4.3 out of 5 stars  See all reviews (29 customer reviews)

Print List Price: £21.99
Kindle Price: £14.20 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £7.79 (35%)
 
Kindle Unlimited Read this title for £0.00 and get unlimited access to over 700,000 titles. Learn More
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.

Formats

Amazon Price New from Used from
Kindle Edition £14.20  
Paperback £14.95  
Kindle Unlimited
Kindle Unlimited
Enjoy unlimited access to over 650,000 titles and thousands of audiobooks on any device for £7.99 a month, including this one. Learn more

Book Description

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.



Product Description

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


More About the Author

John Walkenbach, principal of J-Walk and Associates Inc., is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak. He has written more than 50 books and 300 articles and reviews for publications including PC World, InfoWorld, and Windows. He also maintains the popular Spreadsheet Page at www.j-walk.com/ss, which gets thousands of visitors each month.

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

Most Helpful Customer Reviews
21 of 21 people found the following review helpful
By Matt M
Format:Paperback|Verified Purchase
To put my review into a meaningful context, I will say now that I have been programming for 2-3 years. The thing with this book though, is that almost nowhere within it did I encounter any terminology I would have found intimidating as a beginner. I had wanted to program VBA as it is enormously useful and this book was exactly what I was after.

The author begins by stating the strengths of Excel VBA and also it's history which is interesting enough. He then goes on to talk about the way that VBA programs are structured (if, for, while statements etc.) and how to write handy subroutines and functions. All the while the code is kept to small examples between 5-20 lines and I found that I learnt quickly from copying and tweaking them. These succinct code snippets definitely made progress quick and I found myself using what I had learnt practically straight away in my job.

The books aim is this: To get you to a good enough level of VBA that you can structure your programs nicely and create nice looking forms but giving you the knowledge you need to delve fearlessly into the standard help documentation. Once I had understood how to initialize my variables and write loops and conditional statements, browsing the help led to me finding all sorts of fantastic functions and methods that I had been previously ignorant of. As a result I would say my productivity increased considerably.

The author also provides, early on, a very important chapter on the Excel Object Model(which tells you how the Excel objects are linked to one another) and once you have an understanding of this, the rest will come much more easily. Later on, Chart Objects and User Forms are covered and I think this is the level to which most people would be happy to get to.
Read more ›
Comment | 
Was this review helpful to you?
3 of 3 people found the following review helpful
Format:Paperback|Verified Purchase
I find this book of little use but as I say, it is probably my own fault. If you've not really used spreadsheets before and find the thought of programming in any language baffling, then the book is for you. I'm already an engineering professional and thought it'd be helpful to know a bit more VB, specifically when i'm writing macros for sorting data etc.. Not a particularly good reference book but would be great if you're a complete beginner.
Was this review helpful to you?
2 of 2 people found the following review helpful
Format:Paperback|Verified Purchase
This book is a smaller version of Excel 2013 Power Programming with VBA also written by the same author. It is a handy book to carry in a laptop case to have as a reference wherever you may be. Naturally does not contain as much in his Power Programming book but you could not carry it about.
Well worth buying.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
4.0 out of 5 stars Great Book 10 Jun. 2013
Format:Paperback|Verified Purchase
Really useful book, I am already good with Excel and this has helped me push my skills to a new level and use macros which is great for my work and general understanding and use, does take a little time to get used to and use more of a book to go through page by page rather than look up
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
4.0 out of 5 stars Good starter book 7 May 2014
By G of KI
Format:Paperback|Verified Purchase
OK if you are a bit of a Techi with some programming experience in other languages, but needs reading a few times to understand the concepts. Need a good grounding in Excel first and have some reson in mind wanting to learn VBA in the first place.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
By Matt
Format:Paperback|Verified Purchase
Very informative book, is great for helping you to improve the way you create VBA code.

I was a complete novice but this has helped me to improve how I perform my tasks at work creating simple and complex macros to speed up working.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Excellent introductory course in VBA for Excel. 18 Nov. 2014
Format:Paperback|Verified Purchase
This is an excellent introductory book on VBA and gave me a solid grounding in VBA in only a couple of weeks. The author writes in a generally entertaining way and his enthusiasm about VBA makes the book less dry to read than some titles.

The author is also honest about the pros and cons of VBA, and gives some context about when it is useful or when general purpose programming languages would be more appropriate.

Overall this book gives the reader a solid grounding in programming VBA macros on Excel and I'd strongly recommend it.
Comment | 
Was this review helpful to you?
1 of 1 people found the following review helpful
4.0 out of 5 stars Wanted my own copy 3 Jan. 2014
Format:Paperback|Verified Purchase
I have been using VBA for years. I like the author's style and often borrow this book from others. Just thought it was time I got my own copy.
Comment | 
Was this review helpful to you?
Would you like to see more reviews about this item?
Were these reviews helpful?   Let us know

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category