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 courseware introduces macro programming using Visual Basic for Applications (VBA) to automate and customize operations in Word, Excel, and Access. The instructor will introduce both object oriented and event driven programming techniques. 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
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
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.