Dummies.com
  • Print
  • Share
Excel VBA Programming For Dummies (1118054350) cover image

Excel VBA Programming For Dummies

ISBN: 978-1-118-05435-2
E-book
408 pages
February 2011
US $16.99 Purchase This E-book

This price is valid for United States. Change location to view local pricing and availability.

How to read this e-book on:
Adobe e-books are read using Adobe Digital Editions. Install Adobe Digital Editions on your PC in order to read or transfer your e-book.
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.

  • Print
  • Share