Wrox's growing reputation for putting out well-organized, detail-rich books for programmers gets a boost from Excel 2000 VBA Programmer's Reference. This book--a tutorial as well as a reference--holds a wealth of chewy facts that Excel developers will find very valuable.
The tutorial, accounting for half of the book, covers the various mechanisms available for referring to particular files, sheets, cells, and ranges of cells. It also addresses the graphical representation of data--particularly in charts--and explains the most important aspects of controls and the events they generate. Green--unlike many VBA authors--covers internationalization issues in considerable depth. This is the best VBA book on the market for those planning to write programs for a multilingual usage of Excel. There is also a VBA primer that covers critical VBA syntax and the essentials of object-orientation as it applies to the Excel environment.
The two reference sections--one for Excel's VBA objects and one for the VBA Extensibility (VBE) environment--make up the last half of Excel 2000 VBA Programmer's Reference. The references are comprehensive, but they're organized in a strange way--they list properties, methods, and events with their names, return data types, and descriptions in columns. This would be okay, but when an object's list of members extends over several pages it's impossible to be immediately sure of which object the list refers to. The object name ought to appear on each page. --David Wall [via]