* 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 (www.j-walk.com) on Excel techniques and is the author of many bestselling books on Excel
Auflage
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für Beruf und Forschung
Für höhere Schule und Studium
Illustrationen
Maße
Höhe: 23.2 cm
Breite: 18.6 cm
Dicke: 23 mm
Gewicht
ISBN-13
978-0-7645-7412-2 (9780764574122)
Schweitzer Klassifikation
John Walkenbach is principal of J-Walk and Associates, Inc., a leading Excel expert, and proprietor of the popular spreadsheet page at www.j-walk.com. He has written more than 30 books on Excel.
Introduction.
Part I: Introducing VBA.
Chapter 1: What Is VBA?
Chapter 2: Jumping Right In.
Part II: How VBA Works with Excel.
Chapter 3: Introducing the Visual Basic Editor.
Chapter 4: Introducing the Excel Object Model.
Chapter 5: VBA Sub and Function Procedures.
Chapter 6: Using the Excel Macro Recorder.
Part III: Programming Concepts.
Chapter 7: Essential VBA Language Elements.
Chapter 8: Working with Range Objects.
Chapter 9: Using VBA and Worksheet Functions.
Chapter 10: Controlling Program Flow and Making Decisions.
Chapter 11: Automatic Procedures and Events.
Chapter 12: Error-Handling Techniques.
Chapter 13: Bug Extermination Techniques.
Chapter 14: VBA Programming Examples.
Part IV: Developing Custom Dialog Boxes.
Chapter 15: Custom Dialog Box Alternatives.
Chapter 16: Custom Dialog Box Basics.
Chapter 17: Using Dialog Box Controls.
Chapter 18: UserForm Techniques and Tricks.
Part V: Creating Custom Toolbars and Menus.
Chapter 19: Customizing the Excel Toolbars.
Chapter 20: When the Normal Excel Menus Aren't Good Enough.
Part VI: Putting It All Together.
Chapter 21: Creating Worksheet Functions -- and Living to Tell about It.
Chapter 22: Creating Excel Add-Ins.
Chapter 23: Interacting with Other Office Applications.
Part VII: The Part of Tens.
Chapter 24: Ten VBA Questions (And Answers).
Chapter 25: (Almost) Ten Excel Resources.
Index.
