Cover of VB & VBA in a Nutshell: The Language

VB & VBA in a Nutshell: The Language

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:

Read more

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 Languageis 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 Languageis the definitive reference for Visual Basic and VBA developers.

Subject
science
Themes
technology
Audience
adult
Length
epic · 652 pages

Click a tag to see books like this one that share it.

Read it? Sign in to help tag it.

Liked VB & VBA in a Nutshell: The Language? Here’s where I’d start.

These suit anyone who liked VB & VBA in a Nutshell: The Language. Sign in and mark a few books for picks shaped around your own taste.

  1. Dynamic HTML: The Definitive Reference: The Definitive Reference Shares programming, computers, computer
  2. Learning the Korn Shell Shares programming, computer, technical
  3. Beginning PHP, Apache, MySQL Web Development Shares programming, computer, technical
  4. Learning Cocoa with Objective-C Shares programming, computer, technical

“If you want more of the same (science about technology), start with these.”

  1. PHP 6 and MySQL 5 for Dynamic Web Sites: Visual Quickpro Guide
  2. Systems Performance: Enterprise and the Cloud
  3. Gray Hat Python: Python Programming for Hackers and Reverse Engineers
  4. Programming Pig

“If it was the programming that hooked you, try one of these.”

  1. C Traps and Pitfalls
  2. Beginning C++ Through Game Programming
  3. Version Control with Subversion
  4. Mastering Regular Expressions

“These start from a similar idea, even if they go somewhere else with it.”

  1. Programming PHP
  2. Visual Basic 6 Complete
  3. Head First Programming: A Learner's Guide to Programming Using the Python Language
  4. Professional C#