Excel VBA Programming For Dummies, 3rd Edition
By John Walkenbach
Publisher: Wiley / For Dummies
Final Release Date: January 2013
Pages: 408

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-orientedapplications

Explore VBA programming and learn how to customize and automatemany aspects of Excel

Maybe you're eager to learn Excel programming. Maybe it's yourboss's idea. Either way, this book will have you on your way toExcel programming perfection in no time! It's a plain-English guideto what VBA is, how it works with Excel, essential programmingconcepts, 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 forcreating a program in Excel
  • Macro magic — automate common tasks, create custom buttonsand commands, and develop new worksheet functions using VBAmacros
  • Programming basics — work with range objects, controlprogram flow, automate procedures and events, and exterminate bugsin your code
  • User communication — explore simple and custom dialogboxes and UserForm controls, tricks, and techniques
  • All together now — apply your skills to designuser-oriented applications, create add-ins, and work with otherOffice 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 runtimeerrors
  • Tips for finding and fixing bugs
  • How to customize Excel's user interface
  • Ways to super-charge your formulas with custom worksheetfunctions
  • VBA dos and don'ts
Product Details
Recommended for You
Customer Reviews
 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $29.99
Formats:  ePub, Mobi, PDF