Excel 2007 VBA Programming For Dummies

Front Cover
John Wiley & Sons, Feb 8, 2011 - Computers - 384 pages
3 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

Review: Excel 2007 VBA Programming for Dummies

User Review  - Chand Khan - Goodreads

good Read full review

Review: Excel 2007 VBA Programming for Dummies

User Review  - Goodreads

good Read full review

Selected pages


Communicating with Your Users
Jumping Right
Working In the Visual Basic Editor
Introducing the Excel Object Model
VBA Sub and Function Procedures
Using theExcel Macro Recorder
Automatic Procedures and Events
Writing anEventHandler Procedure
ErrorHandling Techniques
Bug Extermination Techniques
VBA Programming Examples
Simple Dialog Boxes
UserForm Basics
Using UserForm Controls

Essential VBA Language Elements
Working with Range Objects
Using VBA and Worksheet Functions
Controlling Program Flow and Making Decisions
CommandBars andExcel 2007
Creating Worksheet Functions and Living to Tell about
Creating Excel AddIns
Ten VBA Questions And Answers

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