Message from Dean - May 8th 2007

I am currently testing out a new version of the APF Bridge Component - If you notice any errors within this demo store please drop me a line.

Binding: Paperback
Dewey Decimal Number: 005.268
EAN: 9781565923584
Edition: 1st
Format: Illustrated
ISBN: 1565923588
Label: O'Reilly Media, Inc.
Manufacturer: O'Reilly Media, Inc.
Number Of Items: 1
Number Of Pages: 650
Publication Date: October 01, 1998
Publisher: O'Reilly Media, Inc.
Studio: O'Reilly Media, Inc.

---

Related Items:

• VBA Developer's Handbook, 2nd Edition
• Mastering VBA (Mastering)
• Writing Excel Macros with VBA, 2nd Edition
• Access Database Design & Programming (3rd Edition)
• Absolute Beginner's Guide to VBA (Absolute Beginner's Guide)
• see more

Browse for similar items by category:

• Books > Specialty Stores > Custom Stores > By Publisher > O'Reilly > Programming > General
• Books > Specialty Stores > Custom Stores > By Publisher > O'Reilly > Programming > Visual Basic
• Books > Specialty Stores > Custom Stores > By Publisher > O'Reilly > Series > Nutshell
• Books > Specialty Stores > Custom Stores > New & Used Textbooks > Computer Science > Programming Languages
• Books > Specialty Stores > Custom Stores > New & Used Textbooks > Computer Science > General AAS

---

Editorial Review:

Amazon.com 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

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 returned by a function
• The finer points of a keyword's usage that are often omitted from or blurred over by the documentation
• Tips and gotchas that include undocumented behaviors and practical applications for particular language elements -- a section particularly invaluable for diagnosing or avoiding potential programming problems
• A brief, nonobvious example that illustrates the use of the keyword

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.




Rating: - Buy it.
If you have an understanding of VB and need a good reference book, this is it. It will save a lot of the time & frustration experienced when searching with MSDN.

---

Rating: - very handy
this comes in very handy if you are developing with vb/vba on a daily basis. much quicker than using the mostly confusing and badly organized MSDN online references...

---

Rating: - The best learning tool for beginners
It's hard to believe that this book was originally published in 1998. I can't think of any VB programmer I've met that did not have one of these on their desk. This book is meant to be used like a dictionary for VB and VBA. The format is brilliant and the concepts in it are as valid today as they were in 1998.

---

Rating: - Absolutely Great
Well, although there are still many zealous VB 6.0 coders out there, we all know the former language has been superseded by VB.NET, which is basically completely unrelated whatsoever to VB 6.0.

With that being said, I don't plan on becoming a VB coder anyhow, and don't do a lot of programming Web applications anyway. However, there is A LOT that can be accomplished in the Visual Basic language and I find learning VB as a really nice leisure time in between classes, learning hardcore material, or just wanting to enter new territory.

For anyone else who reviews this, please recognize what this book is (and perhaps what it is not): this is a "NUTSHELL" title -- It is not meant to be a defintive tutorial. In fact, the author blatantly states in the preface that the people who will get the most out of this book are those who already have knowledge of VB and are looking for something to refresh their memories or use as a desktop reference.

Now the latter ... Read More

---

Rating: - From a beginner
I have only just started to learn about VB and VBA and as an absolute beginner, I found so far at any rate, this book very easy to absorb and understand. It also gioves a good depth of what VB and VBA is all about. My work has taken me away from home (and frm my computer) for many weeks but the book always goes with me and I am very pleased to have purchased it. I would suggest it is very good for anyone else wishing to consider buying it for the knowledge and style of how the author imparts that knowledge.

---