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 abs...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Beijing :
O'Reilly
1998.
|
| Edición: | First edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627359206719 |
Tabla de Contenidos:
- 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 Sub Main procedure The 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 Data Variant 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
- The Collection Object Passing 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
- When is the Initialize event fired?
