In a Nutshell

Sebastopol : : O'Reilly Media, , 2008.

1 online resource (652 p.)

Description based upon print version of record.. - Table of Contents; Preface; Why Another VB Book?; What's Wrong with the Online Help?; Who Should Read This Book?; An Emphasis on Professional VB Development; How This Book Should Be Used; If You're a Developer New to VB; If You're a VB or VBA Developer; If You're a VB or VBA Developer New to VB6; How This Book Is Structured; The Format of the Language Reference; Conventions Used in This Book; How to Contact Us; Call for Additions and Amendments; Acknowledgments; Part I; Introduction; What Is VBA?; How Does VBA Differ from VB?; How Does VBA Differ from VBScript?. - How Does a VBA Program Differ from a Macro?A Brief History of VBA; What Can You Do with VBA?; Customizing and Creating Applications with VBA; Object Models: The Power of Programming with VBA; Program Structure; Getting a VB Program to Run; Running VBA Modules in Word; Storing your code; At startup; When a document loads; In response to direct user action; Running VBA Modules in Excel; Storing your code; At startup; When a document loads; In response to direct user action; Running VB Executables; Using a Form at Startup; The Form Load and Initialize events; Using a Code Module at Startup. - The Collection ObjectPassing Parameters; ByRef; ByVal; ByRef and ByVal: Performance; Optional Arguments; ParamArray; Intrinsic Constants; Class Modules; Properties; Implementing Properties; The Anatomy of a Property; Private member variable; The Property Let procedure; The Property Get procedure; Property scope; Implementing a User-Defined Type Property; Implementing a Read-Only Property; Using Properties in the Client Application; Using a Mass Assignation Function in Collection Classes; Enumerated Constants; Using Enumerated Constants; Class Module Events; The Initialize Event. - The Sub Main procedureThe Structure of a VB Program; Events: The Starting Point; Use Event Handlers to Call Functions and Methods; Writing Custom Procedures; Functions; Sub procedures; Property procedures; Controlling Execution Flow; Calling sub and function procedures; Explicitly calling event procedures; Ending Your VB Program; How to End Your Program; How a Form Unloads; The End Statement; VBA Variables and Data Types; Visual Basic Data Types; Type Conversion; Implicit Type Conversion in VB; The Variant; Special Variant Data Subtypes; Determining the Variant Subtype. - Variant and Strongly Typed DataVariant and Strongly Typed Functions; Declaring Variables and Constants; Option Explicit; A Whole Load of Nothing; Array Variables; Fixed Arrays; Dynamic Arrays; Determining array boundaries; Setting the lower boundary; Multidimensional Arrays; Dynamic multidimensional arrays; Using UBound and LBound with multidimensional arrays; User-Defined Types; Variable Scope and Lifetime; Procedure-Level Scope; Module-Level or Private Scope; Friend Scope; Public Scope; Object Variables and Binding; Declaring Object Variables; Early and Late Binding: Performance Comparisons. - When is the Initialize event fired?. - 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 inVB & VBA in a Nutshell: The Language, it finally is available. The bulk of the book consists of an alphabetical reference to the s

Electronic books.

005.133

1565923588