Amazon.co.uk Review
VB & VBA in a Nutshell: The Languages documents the latest version of the world's bestselling rapid application development environment. Paul Lomax's explanation of the language comes in two main parts.
First, Lomax explains the structure and syntax of Visual Basic (VB) and Visual Basic for Applications (VBA) programs. He details all the important stuff, including how to work with variables, how to create custom functions, how to create classes, how to handle errors and how to react to user events. If you're up to speed on general programming concepts and just want to know how to get something done in VB/VBA, you'll find this part of the book especially handy.
The second, and largest, part of the book is a language reference in the classic O'Reilly style. Every function, statement, keyword, and miscellaneous bit of code has a clear, complete entry. Each entry includes a statement of syntax, a description of the function's purpose, a quick example of its use and some tips for using it successfully. The reference documents the language as it exists in VB6. --David Wall, Amazon.com
Product Description
The online documentation of VB/VBA language components seems to follow the 80/20 rule: the basic facts that you need to use a language statement are provided in the documentation. But the additional 20 percent that you need to use it effectively or to apply it to special cases is conspicuously absent. To a professional VB/VBA programmer, though, this missing 20 percent of the language's documentation isn't a luxury, it's a necessity. And in VB & VBA in a Nutshell: The Language, it finally is available. The bulk of the book consists of an alphabetical reference to the statements, procedures, and functions of the VB/VBA language. Each entry has a standardized listing containing the following information: Its syntax, using standard code conventions Differences in the operation of the keyword in a macro environment (e.g., in Office) and in Visual Basic, if there are any A list of arguments accepted by the function or procedure, if any A description of the data type and the data returned by a function An extended discussion of the keyword that focuses on some of the finer points of its usage that are often omitted from or blurred over by the documentation Tips and gotchas that focus on undocumented behaviors and practical applications for particular language elements. This section in particular is invaluable for helping the programmer diagnose or altogether avoid potential programming problems. A brief, non-obvious example that illustrate the use of the keyword A cross-reference to other keywords Also included in VB & VBA in a Nutshell: The Language is a brief overview of the VB/VBA language, including: Basic VBA programming concepts, such as its data types and its support for variables, constants, and arrays Error handling in VBA applications Object programming with VBA Using VBA with particular applications. Excel and Project are utilized to show how to work with an application's integrated development environment and to take advantage of its object model Regardless of how much experience you have programming with VBA, this is the book you'll pick up time and time again both as your standard reference guide and as a tool for troubleshooting and identifying programming problems. VB & VBA in a Nutshell: The Language is the definitive reference for Visual Basic and VBA developers.
by Steven Roman
by Rob Bovey
by Ken Getz
by John Walkenbach
