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 VBA Programming For Dummies

Excel VBA Programming For Dummies


By John Walkenbach

ISBN: 978-0-7645-7412-2
Format: Paper
Pages: 408 Pages
Pub. Date: August 2004

E-mail a Friend About This Book
Price: $24.99
Description
Author Information
Table of Contents
Read Excerpt 1 (PDF)
Read Excerpt: Index (PDF)
Read Excerpt: Index (PDF)
Bonus Material
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.

Related Articles
Understanding VBA Functions and Their Uses
Defining VBA and Its Uses
Understanding C#'s "If" Statement
Touring the Design View of Visual Basic 2008
Organizing Your Project with the Solution Explorer
Related Titles
VBA For Dummies, 5th Edition
Excel 2003 Power Programming with VBA
Access VBA Programming For Dummies
Visual Web Developer 2005 Express Edition For Dummies
Visual Basic 2005 Express Edition For Dummies