Excel VBA Programming for Dummies( Dummies Series) FROM THE PUBLISHER
* Shows ordinary users how to harness the power of Visual Basic for Applications (VBA) and create custom Excel applications
* This book introduces people to a wide array of new Excel options, including creating new worksheet functions, automating tasks and operations, creating new toolbars and menus, designing custom dialog boxes and add-ins, and much more
* Begins with the most important tools and operations for the Visual Basic Editor, then provides an overview of the essential elements and concepts for programming with Excel
* John Walkenbach, a.k.a. "Mr. Spreadsheet," runs a popular Web site (j-walk.com) on Excel techniques and is the author of many bestselling books on Excel
Author Biography: John Walkenbach is principal of J-Walk and Associates, Inc., a leading Excel expert, and proprietor of the popular spreadsheet page at j-walk.com. He has written more than 30 books on Excel.
SYNOPSIS
Create new functions, automate tasks, and design add-ins
Become an Excel programmer with VBA, and discover what you can make Excel do
If you want to Excel at spreadsheet creation, VBA is your ticket to greatness. And youre in luck, because "Mr. Spreadsheet" is about to walk you through VBA programming, showing you how to create custom spreadsheets, write macros that make Excel do cool tricks, and more. Open this book and youre on your way!
The Dummies Way Explanations in plain English "Get in, get out" information Icons and other navigational aids Tear-out cheat sheet Top ten lists A dash of humor and fun
Discover how to: Understand and use VBA Automate Excel with macros Find what you need in Excels Help system Design custom dialog boxes, toolbars, and menus Develop user-oriented applications Create custom commands