|
Visual Basic & VBA in a Nutshell: The Languages
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.
Preface
Part I. The Basics
Chapter 1. Introduction
What Is VBA?
A Brief History of VBA
What Can You Do with VBA?
Object Models: The Power of Programming with VBA
Chapter 2. Program Structure
Getting a VB Program to Run
The Structure of a VB Program
Ending Your VB Program
Chapter 3. VBA Variables and Data Types
Visual Basic Data Types
Type Conversion
The Variant
Declaring Variables and Constants
Array Variables
User-Defined Types
Variable Scope and Lifetime
Object Variables and Binding
Passing Parameters
Intrinsic Constants
Chapter 4. Class Modules
Properties
Enumerated Constants
Class Module Events
Implementing Custom Class Methods
Creating ActiveX Components
Using ActiveX Components in a Project
Chapter 5. Automation
Creating Object Model References
Reading the Object Model
Working with the Object Model
Collection Objects
Trapping an Automation Server's Events
Automation Examples
Automation Performance Tips
Chapter 6. Error Handling
Building a Robust Application
Error Handling in Procedures
Error Handling in ActiveX Servers
Reporting Errors
Part II. Reference
Chapter 7. The Language Reference
Part III. Appendixes
Appendix A. Language Elements by Category
Appendix B. Language Constants
Appendix C. Operators
Appendix D. What's New in VB6?
Index
|
