Excel VBA Programming for Dummies( Dummies Series)

Create new functions, automate tasks, and design add-ins

Become an Excel programmer with VBA, and discover what you can make Excel do

If you want to Excel at spreadsheet creation, VBA is your ticket to greatness. And you’re in luck, because "Mr. Spreadsheet" is about to walk you through VBA programming, showing you how to create custom spreadsheets, write macros that make Excel do cool tricks, and more. Open this book and you’re on your way!

The Dummies Way

• Explanations in plain English
• "Get in, get out" information
• Icons and other navigational aids
• Tear-out cheat sheet
• Top ten lists
• A dash of humor and fun

Discover how to:

• Understand and use VBA
• Automate Excel with macros
• Find what you need in Excel’s Help system
• Design custom dialog boxes, toolbars, and menus
• Develop user-oriented applications
• Create custom commands

John Walkenbach is principal of J-Walk and Associates, Inc., a leading Excel expert, and proprietor of the popular spreadsheet page at www.j-walk.com. He has written more than 30 books on Excel.