Excel VBA Programming; About the Author; Author's Acknowledgments; Contents at a Glance; Table of Contents; Introduction; Part I: Introducing VBA; Part II: How VBA Works with Excel; Part III: Programming Concepts; Part IV: Developing Custom Dialog Boxes; Part V: Creating Custom Toolbars and Menus; Part VI: Putting It All Together; Part VII: The Part of Tens; Index; Bonus Chapter 1: Creating Excel Applications for Others; Bonus Chapter 2: Ten VBA Tips and Tricks
Summary
Shows ordinary users how to harness the power of Visual Basic for Applications (VBA) and create custom Excel applicationsThis 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 moreBegins 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 ExcelJohn Walkenbach, a.k.a. ''Mr. Spreadsheet, '' runs a popular Web site (www.j