Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

VDCI

Excel VBA and Macros Level II

via VDCI

Go to class Write review

Overview

Get hands-on with VBA and macros in this practical training course. You'll work through everything from the VBA Editor and writing and editing code to running macros, working with objects, logical statements, functions, looping, interactive code, and error handling.

Syllabus

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

Reviews

Start your review of Excel VBA and Macros Level II

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.