Microsoft Excel Macro Programming Using VBA

Planning Information

The duration of this course is 1 Day. The list price is $375.00.

Description

The Visual Basic for Applications programming language is a powerful addition to all Office, and particularly useful in Microsoft® Excel®.

Intended Audience

The Excel VBA class is intended for students who wish to enhance their knowledge of Excel and utilize the power of macros to automate tasks. 

At Completion

Upon completion of this course, students will have a basic understanding of VBA and the macros produced by it. They will also leave with a set of working macros that cover basic logic and functionality. 

Prerequisites

Students should know how to create and save workbooks, create formulas, use basic functions. 

Materials

Courseware Microsoft Office Excel 2007: VBA Programming

Course Outline

Lesson 1 : The Visual Basic Editor

  • Visual Basic for Applications (VBA)
  • Object programming
  • The Object Browser

Lesson 2: Programming Basics

  • Data basics
  • Scope of variables
  • Scope of procedures

Lesson 3: Control Structures

  • Decision structures
  • Loop structures
  • Control structures

Lesson 4: Custom Dialog Boxes

  • User Forms
  • Events

Lesson 5: Debugging and Error Handling

  • Errors
  • Debugging
  • Error handling
  • Debugging and error handling



Related Courses

Pin It on Pinterest