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