Excel 7.0: Int. Visual Basic (Windows 95)

Students will learn to create and edit macros, and gain an understanding of VBA code.

Prerequisites

Windows Orientation, Excel 7.0: Worksheets, and Excel 7.0: Advanced or equivalent knowledge.

Target Student

Students enrolling in this course should understand the basic concepts involved in working with a personal computer (PC). For example, they should be familiar with the components that make up the personal computer, including input, output, and storage devices.

Performance-Based Objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

Understand the basics of a Visual Basic Module.
Understand how to execute one or more lines of code repetitively.
Understand relative and absolute recorded macros, and assign these macros to various objects.
Create macros that interact with the user.
Create custom functions.
Analyze how your code operates and locate the source of errors.
Write procedures that test conditions and then run only certain statements based on the results.
Organize your macros for easy access.

Delivery Method

Instructor-led, group-paced, classroom-delivery learning model with structured, hands-on activities.

Course duration

1 Day(s) Course outline

Lesson 1: Introduction to Visual Basic Applications

Running a macro
Recording a macro
Examining module design

Lesson 2: Assigning macros

Specifying the location of recorded macros
Assigning shortcut keys to macros
Assigning macros to menus
Assigning a macro to a button on a sheet
Assigning a macro to a button on a toolbar

Lesson 3: Creating decision-making code

The If...Then decision structure
The If...Then...Else decision structure
The Select Case decision structure

Lesson 4: Using loop structures

Using a For...Next statement
Using a Do...Loop statement
Using a For Each...Next statement

Lesson 5: User-defined functions and variables

Creating user-defined functions
Using variables

Lesson 6: Interactive macros

Creating a custom message box
Creating a custom input box
Previewing custom dialog boxes

Lesson 7: Debugging and testing code

Overview of debugging
Stepping through the code
Using Watch Expressions

Lesson 8: Macro management

Personal Macro Workbook
Assigning Sub procedures to run automatically

Hardware/Software Requirements

You will need 6 megabytes (MB) of Random Access Memory (RAM) if you are using Excel 7.0. See your reference manual for hardware considerations that apply to your specific hardware setup. In addition, you will need printers if you want to print portions of the workbooks created in the course.