The Macro Recorder
- Personal Macro Workbook
- Viewing your code in the VBE
- The Visual Basic Editor’s Code Window
Making your code generic
Intellisense
- Using Intellisense for Parameters & Constants
- VBA fundamentals: Objects
- The Workbook, Worksheet and Range Objects
- Defining Workbook and Worksheet Objects
- Defining a Worksheet Range
- Implicit and Explicit declaration of objects
Method & Property Examples
- Worksheets
- Ranges
- Workbooks
- Standard Variables
- Object Variables
- Why bother pre-defining Variables?
- Setting & Using Variables
- Arrays
- Declaring Arrays
- Populating Arrays
- IF (ElseIf, Else)
- Select Case()
- For Next Loop
- For Each Loop()
- Do Until Loop and Do While Loop
- With, End With
- Nesting Code
Scope & Code Location
Functions, Routines & Arguments
- Definitions
- Passing Parameters to a Function
- Multiple and Optional Parameters
- Passing Parameters back and forth between Routines
Error Handling
The VBE in detail
Manipulating Text
Triggering code with Events
- Events with Parameters
Interacting with the user
- Msgbox
- Application.StatusBar
- Using the generic toolbar
