Excel VBA and Macros Level I

Lesson 1: Macros / VBA

• What are Macros?
• What is VBA?
• How to record macros
• How to run macros

Lesson 2: VBA Editor

• Modules
• Procedures
• Project Explorer
• Toolbars / Options

Lesson 3: Creating / Editing Code

• Create Procedures
• Subs
• Comments

Lesson 4: Invoking Macros

• Hot Keys
• Quick Access Toolbar
• Call Command

Lesson 5: Compiling Code

• Stepping through code
• Reset
• Run

Lesson 6: Variables

• Declarations
• Option Explicit
• Data Types

Lesson 7: Working with The Object Model

• Worksheets
• Ranges: Rows, Columns, Cells

Lesson 8: Creating & Naming Objects

• Naming conventions
• Housekeeping

Lesson 9: Navigation / Selection Techniques

• Formula R1C1 Reference Style
• Offsets
• Range Names

Lesson 10: Logic Statements

• IF Statements

Lesson 11: Looping Statements

• Do Loops

Lesson 12: Interactive Code

• Input boxes
• Message boxes

Lesson 13: Error Handlers

• Preventing fatal errors and crashes