Skip to main content

VBA For Dummies, 3rd Edition

VBA For Dummies, 3rd Edition

Steve Cummings

ISBN: 978-0-764-50856-1

Jun 2001

432 pages

Select type: Paperback

Product not available for purchase


VBA For Dummies is a real card-carrying Dummies title with its fresh, conversational and irreverent style, yet it still covers VBA programming with real depth and accuracy. The book starts with a brief background on VBA and an explanation of key jargon and theoretical concepts. Then you jump right into the practical programming covering topics such as: VBA development environment; Visual Basic Editor; Meat and potatoes coding techniques; Database programming with VBA; Detailed Microsoft Office-specific tips and tricks; and Coverage of non-Microsoft VBA applications, including CorelDraw and Word Perfect.

Not all applications instantly give developers what they need out of the box. VBA For Dummies, 3rd Edition makes it easy for programmers to customize software from Microsoft and others with Visual Basic for Applications.


PART I: VBA Boot Camp.

Chapter 1: Don't Sweat the Technical Stuff — and It's All Technical Stuff.

Chapter 2: Don't Program When You Can Record a Macro.

Chapter 3: Basic VBA Programming.

Chapter 4: Running VBA Programs.

Chapter 5: The Visual Basic Editor at Your Command.

PART II: VBA Programming Essentials.

Chapter 6: Anatomy of a Great VBA Program.

Chapter 7: Storing and Modifying Information.

Chapter 8: Controlling the Flow.

Chapter 9: Unbreakable Code: Debugging and Error Trapping.

Chapter 10: Creating Interactive VBA Forms.

PART III: Stretching Out.

Chapter 11: Built-in VBA Commands.

Chapter 12: Object-Oriented Programming.

Chapter 13: Baskets for Data Storage: Arrays and Collections.

PART IV: The Part of Tens.

Chapter 14: Ten (Minus Three) Really Cool Things You Can Do with VBA.

Chapter 15: Ten (Times Three) VBA Resources.

Appendix: About the CD.

BONUS PART: Extras (On the CD-ROM).

Bonus Chapter A: VBA Programming in Office.

Bonus Chapter B: VBA Programming in Word.

Bonus Chapter C: VBA Programming in Excel.

Bonus Chapter D: Database Programming.

Bonus Chapter E: Working with Disk Files.

Bonus Chapter F: More on VBA Forms.


Hungry Minds End-User License Agreement.

Installation Instructions.

View the Companion Site

View the Companion Site for this title.