Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Microsoft Excel 2007 Level 3 - VBA Macros

GK# 8759

Course Overview

TOP

In this 2-day instructor-led course, you will learn advanced functions related to Visual Basic for Applications (VBA) macros in Excel 2007. This intensive course will take you from the key concepts to advanced layout, design, and error-handling.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • Examine key concepts that are used to build custom solutions using Microsoft Excel VBA Macros
  • Learn basic macro techniques for recording, writing, running, and maintaining macros
  • How Visual Basic for Applications is incorporated, used, and modified in Microsoft Excel
  • Design and lay out a user form and controls to create a customized dialog box to simplify data entry
  • Prepare an Excel Workbook containing macros and toolbars for deployment to other users and machines
  • Customize macros with VBA source code to automate data entry tasks and enable source code protection
  • Enhance source code with variables, constants, and logical operators
  • Handle the three types of errors that can be generated when working with source code
  • Access external data by using ActiveX Data Objects
  • Use Excel as an automation server to control Excel objects externally outside of the application

Outline

TOP
Viewing outline for:

Classroom Live Outline

Building Solutions

  • Course Overview
  • Solution Concepts
  • Data Entry Concepts
  • Macro Concepts
  • Programming Concepts

Macro Basics

  • Planning Macros
  • Recording Macros
  • Executing Macros
  • Maintaining Macros

VBA Programming Basics

  • Understanding Objects
  • Using the Visual Basic Editor
  • Understanding VBA Code
  • Executing VBA Code
  • VBA Help Reference

VBA User Form Basics

  • Planning User Forms
  • Designing User Forms

Deployment Basics

  • Preparing for Deployment
  • Code Security
  • Creating Custom Toolbars
  • Creating Custom Macro Buttons

Enhancing VBA Code

  • Writing Source Code
  • Variables and Constants
  • Writing Tips
  • Logical Operators
  • Flow Control

Handling Errors

  • Handling Errors
  • Syntax Errors
  • Logical Errors
  • Run-Time Errors

Accessing External Data

  • External References
  • ActiveX Data Objects Concepts
  • Connecting to a Database
  • Retrieving Records from a Database

Excel Automation

  • Automation Concepts
  • Working with Object Models
  • Excel's Object Model
  • Automating Excel with VBScript

Prerequisites

TOP

Who Should Attend

TOP

Those who are familiar with Excel 2007 and want to learn to use macros to automate functions and to develop applications using Excel as the platform

Follow-On Courses

TOP
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 2 day

Request this course in a different delivery format.
Enroll