Roman S. Writing Excel Macros with VBA

O’Reilly & Associates, Inc., 2002. - 476 p.
2nd edition.Рассматриваются версии MS Excel 97 и 2000, но книга является достаточно актуальной и для последующих версий.This book provides an introduction to programming the Excel object model using Visual Basic for Applications (VBA). However, it is not intended to be an encyclopedia of Excel programming.
The goal here is to acquaint you with the main points of Excel programming—enough so that you can continue your education (as we all do) on your own. The goal is that after reading this book you should not need to rely on any source other than the Excel VBA Help file or a good Excel VBA reference book and a nice object browser (such as my Enhanced Object Browser, a coupon for which is included in the back of this book).
It has been my experience that introductory programming books (and, sadly, most trade computer books) tend to do a great deal of handholding. They cover concepts at a very slow pace by padding them heavily with overblown examples and irrelevant anecdotes that only the author could conceivably find amusing, making it difficult to ferret out the facts.The VBA Environment
Preliminaries
CThe Visual Basic Editor, Part I
The Visual Basic Editor, Part II
The VBA Programming Language
Variables, Data Types, and Constants
Functions and Subroutines
Built-in Functions and Statements
Control Statements
Excel Applications and the Excel Object Model
Object Models
Excel Events
Custom Menus and Toolbars
Built-In Dialog Boxes
Custom Dialog Boxes
The Excel Object Model
The Application Object
The Workbook Object
The Worksheet Object
The Range Object
Pivot Tables
The Chart Object
Smart TagsРусский перевод книги: см. /file/38364/