VB and 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:

  • 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.


Designed for programmers, this desktop quick reference covers Visual Basic 5 & 6 and the hosted language Visual Basic for Applications (VBA). VBA is widely used as the binding glue between Microsoft office products and application technologies. To derive the most benefit from this reference, you should be familiar with VB, the Windows environment, the object model, VB basic structure and VB syntax.

Author(s): Paul Lomax  

ISBN 10: 1565923588
ISBN 13: 9781565923584
Pages: 652
Find this book on Amazon

 

This books is in the following lists (2)



Related YouTube Videos (add a video)

Add the YouTube URL below and submit:

To add a YouTube video, please copy the video's URL on YouTube and submit by clicking "Add".
The URL should look something like this: https://www.youtube.com/watch?v=CXQdBuuanI8
How to copy the videos URL from YouTube

No video yet, want to add one?

Related Articles (add an article)

Add an article URL below and submit:

To add an article, please paste the article's URL and submit by clicking "Add".
Below is an example of a valid URL:
How to copy and paste a webpage URL

No article found, do you know any related to this book?

Report an error with this book