Excel VBA and Macros Level II

Lesson 1: VBA Editor

• Project Explorer
• Properties Window
• Modules

Lesson 2: Creating / Editing Code

• Functions
• Events

Lesson 3: Invoking Macros

• Worksheet Buttons
• Customize Ribbon

Lesson 4: Compiling Code

• Stepping through code
• Setting Breakpoints

Lesson 5: Variables

• Declarations
• Option Compare Text
• Option Compare Binary
• Lifetime and Scope

Lesson 6: Working with The Object Model

• Application
• Workbook

Lesson 7: Creating & Naming Objects

• Naming conventions
• Housekeeping

Lesson 8: Navigation / Selection Techniques

• Absolute versus Relative Reference
• Offsets

Lesson 9: Logic Statements

• Nested IF Statements
• Case Statements

Lesson 10: Functions

• Intrinsic Functions
• User Defined Functions

Lesson 11: Looping Statements

• For Each Next Loops

Lesson 12: Interactive Code

• User Forms - dashboards
• Message Boxes

Lesson 13: Error Handlers

• Error numbers
• Error descriptions

• Students may cancel up to 11 business days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price).
• Cancellations within 11 business days are not permitted, but students may reschedule up to 4 business days before the class start date.

For cancellations and reschedules, please email us at [email protected]