Topics
- Keywords
- Declaring Variables
- Procedure Calls
- Naming Conventions
- Creating a procedure
- Flow control structures
- Arrays
- Error Handling
- Recursion
- Conditional Compilation
- Substrings
- VBA Option Keyword
- Creating a Custom Class
- Events
- Attributes
- User Forms
- Object-Oriented VBA
- Passing Arguments ByRef or ByVal
- VBA Run-Time Errors
Examples
- Variables
- Access Modifiers
- Type Hints
- Implicit Call Syntax
- Return Values
- This is confusing. Why not just always use parentheses?
- Explicit Call Syntax
- Variable Names
- Procedure Names
- Introduction to procedures
- using
- For Each loop
- Avoiding error conditions
- On Error statement
- Resume keyword
- Custom Errors
- Using Declare Imports that work on all versions of Office
- Iterating elements of an array
- Declaring Fixed-Length Strings
- Sources and Handlers
- Passing data back to the event source
- VB_Description
- VB_[Var]UserMemId
- Best Practices
- Handling QueryClose
- Abstraction
- Encapsulation
- Polymorphism
- ByRef
- Run-time error '3': Return without GoSub
- Run-time error '6': Overflow
- Run-time error '9': Subscript out of range
- Run-time error '13': Type mismatch
- Run-time error '91': Object variable or With block variable not set
- Run-time error '20': Resume without error
- ByVal
