Short description
Shows ordinary users how to harness the power of Visual Basic for Applications (VBA) and create custom Excel applications. This book introduces people to an array of 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.
Long description
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 on Excel techniques and is the author of many best-selling books on Excel.