Excel 2007 VBA Programming For Dummies

Front Cover
John Wiley & Sons, Feb 8, 2011 - Computers - 384 pages
2 Reviews
Step-by-step instructions for creating VBA macros

Harness the power of VBA and create custom Excel applications

Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.

Discover how to

  • Grasp essential programming concepts
  • Use the Visual Basic Editor
  • Navigate the new Excel user interface
  • Communicate with your users
  • Deal with errors and bugs
 

What people are saying - Write a review

User Review - Flag as inappropriate

5

Contents

Introduction
1
Part I Introducing VBA
9
Part II How VBA Works with Excel
33
Part III Programming Concepts
91
Part IV Communicating with Your Users
221
Part V Putting It All Together
315
Part VI The Part of Tens
345
Index
355
Bonus Chapter 1 Interacting with Other Office Applications
369
Bonus Chapter 2 Ten VBA Dos and Donts
381
Copyright

Other editions - View all

Common terms and phrases

About the author (2011)

John Walkenbach is a leading authority on spreadsheet software and creator of the award-winning Power Utility Pak.

Bibliographic information