Walkenbach John. Microsoft Excel VBA Programming For Dummies

Wiley Publishing, Inc., 2010. – 403 pages.
- 2nd Edition.This book is written for Excel 2007 and Excel 2010, so if you don’t have one of those versions, you run the risk of getting confused in a few places.Introducing VBA.
What Is VBA?
Jumping Right In.
How VBA Works with Excel.
Working In the Visual Basic Editor.
Introducing the Excel Object Model.
VBA Sub and Function Procedures.
Using the Excel Macro Recorder.
Programming Concepts.
Essential VBA Language Elements.
Working with Range Objects.
Using VBA and Worksheet Functions.
Controlling Program Flow and Making Decisions.
Automatic Procedures and Events.
Error-Handling Techniques.
Bug Extermination Techniques.
VBA Programming Examples.
Communicating with Your Users.
Simple Dialog Boxes.
UserForm Basics.
Using UserForm Controls.
UserForm Techniques and Tricks.
Accessing Your Macros through the User Interface.
Putting It All Together.
Creating Worksheet Functions — and Living to Tell about It.
Creating Excel Add-Ins.
The Part of Tens.
Ten VBA Questions (And Answers).
(Almost) Ten Excel Resources.