VB and VBA in a Nutshell: The Languages

In a Nutshell

by Paul Lomax, Ron Petrusha

VB & VBA in a 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

Genres: Programming, Technical, Reference, Computers, Nonfiction

633 pages, Paperback

First published October 1, 1998

Reviews

[Manny Tingplants · Rating 5 out of 5]

An excellent extension of the available Microsoft help docs for anyone using VBA for Office automation. Largely a reference index, but there are a few chapters of conceptual explanation. Strictly covers the VBA language, not the VB6 IDE or any particular Office program's automation library. This much-needed specialization of scope is what makes this book so valuable for anyone using VBA; many peer books focus strictly on Excel or Word, or VB6 development at large.

[Joe · Rating 5 out of 5]

This is the essential reference for VB and VBA programming. Friends don't let friends develop or maintain VB(A) code without it.

[Ken Guest · Rating 4 out of 5]

Useful if VB is your poison.