Table of contents
- Avoiding Naming Conflicts
- Calling Procedures with the Same Name
- Calling Property Procedures
- Calling Sub and Function Procedures
- Creating Object Variables
- Creating Recursive Procedures
- Declaring Arrays
- Declaring Constants
- Declaring Variables
- Executing Code when Setting Properties
- Looping Through Code
- Making Faster For...Next Loops
- Passing Arguments Efficiently
- Returning Strings from Functions
- Understanding Automation
- Understanding Conditional Compilation
- Understanding Named and Optional Arguments
- Understanding Objects, Properties, Methods, and Events
- Understanding Parameter Arrays
- Understanding Scope and Visibility
- Understanding the Lifetime of Variables
- Understanding Variants
- Understanding Visual Basic Syntax
- Using Arrays
- Using Constants
- Using Data Types Efficiently
- Using Do...Loop Statements
- Using For Each...Next Statements
- Using For...Next Statements
- Using If...Then...Else Statements
- Using Parentheses in Code
- Using Select Case Statements
- Using With Statements
- Visual Basic Naming Rules
- Working Across Applications
- Writing a Function Procedure
- Writing a Property Procedure
- Writing a Sub Procedure
- Writing Assignment Statements
- Writing Data to Files
- Writing Declaration Statements
- Writing Executable Statements
- Writing Visual Basic Statements