I have developed and used this courseware for over 15 years to teach Visual Basic for Applications (VBA) to over 500 students. It is intended to be used as a resource tool for the instructor or as a standalone workbook for the student.

This student workbook is to be used as courseware for an instructor led 10 to 12 hour course. The workbook introduces macro programming using Excel Visual Basic for Applications (VBA) to automate and customize operations in Word, Excel, and Access. The author will introduce programming techniques thru many exercises. The Visual Basic editor will be used to create user interfaces, write VBA code, execute and debug programs. Content includes good programming practices, object naming conventions, flow charting, writing VBA code procedures, procedural scope, dimensioning variables, dialog boxes, looping, decision-making with If Functions, running macros automatically, recording a macro and understanding the necessity to document program code.

This courseware covers the second of two "12" hour courses that covers additional VBA programming with the following topics:

VBA Color Constants and the RGB Function

Working with Additional Properties and Controls

The Temperature Conversion Program

Flow Charting

Making Decisions with Visual Basic Code

Making Decisions with If Statements

Using If...Then Statements to Make Decisions

Using If...Then...Else Statements to Make Decisions

Working with Multiple If Statements

Using Select Case Statements to Make Multiple Decisions

Using Dialog Boxes

Displaying a Message Using the MsgBox Statement

Modal and Modeless Dialog Boxes and UserForms

Getting Return Values Using the MsgBox Function

Using the “Return Values” in a Message Box Function

Getting Input Using the InputBox Function

Using the Input Box Function

Introduction to Error Trapping

Converting Inches to Centimeters (Homework)

Debugging Visual Basic Macro Code

Using Breakpoints to Debug a Macro

Using Loops

The Do … Loop

The For .... Next Loop

Using a Form to enter data onto a Worksheet

The VBA Timer Function

Running Macros Automatically

Opening an Excel Workbook Automatically

Using Mathematical Functions in Formulas

Working with Form Controls

This courseware includes many supporting documents.

Reasonable cost "site licensing" available for student workbooks.

This is the second of two courses.