Index
A
- Addin
- about / How can you use this technology within your existing projects?
- Add method
- about / Subroutines
- API Viewer
- about / Classes
- Application Programming Interface (APIs)
- about / What kind of things can you do with it?
B
- blogs
- URLs / Blogs
- bugs
- about / The Immediate window
C
- classes
- about / Classes
- graphical representation / Classes
- Const
- about / Working with variables
D
- debugging
- about / The Immediate window
- Dim
- about / Working with variables
- Do-Until loop
- about / Method 3 – Do-While and Do-Until loops
- Do-While loop
- about / Method 3 – Do-While and Do-Until loops
- Dynamic-link Libraries (DLLs)
- about / What kind of things can you do with it?
E
- early binding
- about / Dimensioning and instantiating objects
- enumeration
- about / Enumeration
- Excel
- URLs, for Official Sites / Official sites
- URLs, for resources / Resources
- blogs / Blogs
- twitters / Twitter
- Excel ActiveX Data Objects (ADO) coding
- URL / Articles and tutorials
- explicit variable declaration
- about / Working with variables
- external libraries
- about / External libraries
F
- FileSystemObject / Dimensioning and instantiating objects
- For-Next loops
- about / Method 1 – For-Next loops
- For Each-Next Loops
- about / Method 2 – For Each-Next Loops
- functions
- about / Functions
- built-in functions / Functions
I
- Immediate window
- about / The Immediate window
- displaying / The Immediate window
- uses / The Immediate window
- problems, debugging in code / The Immediate window
- procedure or function, calling / The Immediate window
- code, executing / The Immediate window
- implicit declaration
- about / Working with variables
- Interact with Outlook from Excel
- URL / Articles and tutorials
L
- late binding
- about / Dimensioning and instantiating objects
- loops
- working with / Working with loops
- For-Next loops / Method 1 – For-Next loops
- For Each-Next Loops / Method 2 – For Each-Next Loops
- Do-Until loop / Method 3 – Do-While and Do-Until loops
- Do-While loop / Method 3 – Do-While and Do-Until loops
M
- macro
- about / Recording a macro
- recording / Recording a macro
- recording, from status bar / Option 1 – Recording a macro from the status bar
- recording, from Developer tab / Option 2 – Recording from the Developer tab
- macro-enabled workbook
- saving / Saving a workbook containing macros
- module
- adding / Adding a module
O
- Object Browser
- about / Browsing objects
- Object Model (OM)
- about / Method 2 – For Each-Next Loops
- objects
- dimensioning / Dimensioning and instantiating objects
- instantiating / Dimensioning and instantiating objects
- Official forums
- URL / Community
- optional argument
- about / Subroutines
P
- private variable
- about / Working with variables
- public variable
- about / Working with variables
R
- referencing
- about / Method 2 – For Each-Next Loops
- required argument
- about / Subroutines
- routines
- about / Subroutines
S
- SheetIndex
- about / Subroutines
- Static
- about / Working with variables
- subroutines
- about / Subroutines
T
- twitters
- URLs / Twitter
U
- Unofficial forums
- URL / Community
- User-defined Functions (UDFs)
- about / What kind of things can you do with it?
V
- variables
- about / Working with variables
- working with / Working with variables
- VBA
- about / So, what is VBA?
- features / The basic features of VBA
- functions / What kind of things can you do with it?
- using / How can you use this technology within your existing projects?
- code, executing / Executing your code
- macro-enabled workbook, saving / Saving a workbook containing macros
- module, adding / Adding a module
- objects, browsing / Browsing objects
- variables, working with / Working with variables
- Immediate window / The Immediate window
- VBA programming
- about / Quick start – VBA programming
- loops, working with / Working with loops
- For-Next loops / Method 1 – For-Next loops
- For Each-Next loops / Method 2 – For Each-Next Loops
- Do-Until loop / Method 3 – Do-While and Do-Until loops
- Do-While loop / Method 3 – Do-While and Do-Until loops
- objects, dimensioning / Dimensioning and instantiating objects
- objects, instantiating / Dimensioning and instantiating objects
- subroutines / Subroutines
- user-defined functions / Functions
- VBA programming features
- about / Top features you'll want to know about
- enumeration / Enumeration
- classes / Classes
- external libraries / External libraries