Everyday Computing Advanced Computing The Internet At Home Health, Mind & Body Making & Managing Money Sports & Leisure Travel Beyond The Classroom
Certification
Databases
Networking
Programming
Win a Trip to New York City to see Monty Python's SPAMALOT!
Excel 2007 VBA Programming For Dummies

Excel 2007 VBA Programming For Dummies


By John Walkenbach, Jan Karel Pieterse

ISBN: 978-0-470-04674-6
Format: Paper
Pages: 368 Pages
Pub. Date: February 2007

E-mail a Friend About This Book
Price: $24.99
Description
Author Information
Table of Contents
Read Excerpt: Chapter (PDF)
Read Excerpt: Table of Contents (PDF)
Read Excerpt: Index (PDF)
Bonus Chapters and Code
Introduction.

Part I: Introducing VBA.

Chapter 1: What Is VBA?

Chapter 2: Jumping Right In.

Part II: How VBA Works with Excel.

Chapter 3: Working In 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: Communicating with Your Users.

Chapter 15: Simple Dialog Boxes.

Chapter 16: UserForm Basics.

Chapter 17: Using UserForm Controls.

Chapter 18: UserForm Techniques and Tricks.

Chapter 19: Accessing Your Macros Through the User Interface.

Part V: Putting It All Together.

Chapter 20: Creating Worksheet Functions and Living to Tell about It.

Chapter 21: Creating Excel Add-Ins.

Part VI: The Part of Tens.

Chapter 22: Ten VBA Questions (And Answers)

Chapter 23: (Almost) Ten Excel Resources.

Index.

Related Articles
Integrating Access 2003 with Other Microsoft Office Applications
Understanding VBA Functions and Their Uses
Defining VBA and Its Uses
Fabricating Those Fabulous Formulas in Excel
Viewing Outlook Contacts by Group
Related Titles
Excel 2003 Power Programming with VBA
Access VBA Programming For Dummies
Excel VBA Programming For Dummies
Visual Web Developer 2005 Express Edition For Dummies
Visual Basic 2005 Express Edition For Dummies