Excel VBA Programming for Dummies: Third Edition

Walkenbach, John

ISBN 10: 1118490371 / ISBN 13: 9781118490372

Published by For Dummies, 2013

A copy that has been read, remains in good condition. All pages are intact, and the cover is intact. The spine and cover show signs of wear. Pages can include notes and highlighting and show signs of wear, and the copy can include "From the library of" labels or previous owner inscriptions. 100% GUARANTEE! Shipped with delivery confirmation, if youâ re not satisfied with purchase please return item for full refund. Ships via media mail. Seller Inventory # OTV.1118490371.G

Synopsis:

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

More

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

Bibliographic Details

Title: Excel VBA Programming for Dummies: Third ...
Publisher: For Dummies
Publication Date: 2013
Binding: Soft cover
Condition: good
Edition: 3rd Edition