Microsoft Excel 2000 - VBA

Overview

Enhance Excel workbooks by adding User Defined Functions, communicate using Input and Message dialog boxes and troubleshoot or enhance existing VBA macros in a workbook.

Target Audience

This course is aimed at advanced users of Microsoft Excel who wish to automate workbooks using VBA code or edit and fix existing VBA code in existing workbooks.

Prerequisites

It is essential that course participants have successfully completed the Excel 2000 Expert course, or have gained a similar level of knowledge within the work environment. Specifically participants need to be fully conversant in:

  • Creating Macros in Excel using the Macro Recorder.
  • Excel objects (Worksheets, Workbooks, and Functions etc).

Objectives

Upon completion users will be able to:

  • Create basic VBA Macros to automate Excel spreadsheets.
  • Create User Defined Functions.
  • Create Input and Message boxes to communicate with the user.
  • Create forms to collect information from a user and place it on a spreadsheet.
  • Use control structures to make decisions.

Duration

2 days.

Course Content

Visual Basic Editor

  • Visual Basic for Applications
  • Examining the VBE Window
  • Object Programming
  • Examining the Properties Window
  • Changing the Object Properties
  • Using Code to Change Object Properties
  • Using a Method
  • Associating VBA Code with an Event
  • Executing VBA Code by Using a Button
  • The Object Browser

Programming Basics

  • Discussing Data Types and Variables
  • Using Operators
  • Using the Interaction Functions
  • Scope of Variables
  • Understanding Procedures
  • Understanding Scope
  • Creating a Sub Procedure
  • Calling a Sub Procedure
  • Calling a Function Procedure

Control Structures

  • Decision Structures
  • Using the If…Then Statement
  • Using the If…Then…Else Statement
  • Using the Select Case Statement
  • Loop Structures
  • Using the For…Next loop

Custom Dialog Boxes

  • User Forms
  • Adding a User Form
  • Adding Controls to a User Form
  • Attaching an Event Handler to a Control

Debugging and Error Handling

  • Discussing Types of Errors
  • Discussing Debugging Tools
  • Setting a Breakpoint
  • Using Step Into
  • Working with Debugging Windows

Back



 
 
 

Download

Download this profile here.
 

Also Available

Microsoft Excel 2000 Core
Microsoft Excel 2000 Proficient
Microsoft Excel 2000 Expert