Walkenbach J. Microsoft Excel VBA Programming For Dummies

Wiley Publishing, Inc., 2010. – 403 pages.Getting Started uJith Excel VBA Programming.
What Is VBA?
Jumping Right In.
Work 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 our Users.
Simple Dialog Boxes.
User Form Basics.
Using UserForm Controls.
UserForm Techniques and Tricks.
Accessing Your Macros through the User Interface.
Putting It Alt 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.
Ten VBA Do’s and Don’ts.