Nicht lieferbar
Excel VBA Programming For Dummies
Versandkostenfrei!
Nicht lieferbar
Weitere Ausgaben:
* 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 sit...
* 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
AUS DEM INHALT:
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.
* 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
AUS DEM INHALT:
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.