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 is an excellent "12" hour class that covers the basics of VBA programming with the following topics:
What is Object-Oriented Programming?
What is Event-Driven Programming?
Introduction to Visual Basic for Applications (VBA)
Understanding and Creating Command Macros
The VBA Interface
Creating Controls on the UserForm Window
Designing and Building Applications with VBA
The Visual Programming Phase
Creating the User Interface
Changing the Look of UserForms
Object Naming Conventions
Building UserForms from Property Tables
The Code Programming Phase
Attaching Visual Basic Code to the Objects
Scope of Procedures
Assigning Values to the Properties of Objects
Working with Event Procedures
Working with and Declaring Variables
Visual Basic Variable Data Types
Working with and Declaring Constants
Scope of Variables
How to Manage Multiple UserForms
Using VBA Modules
Understanding Modules and Projects in Visual Basic Editor
Running VBA Code from a Module
Creating VBA Macros using the Macro Recorder
Where are Macros Stored?
This courseware includes many supporting documents.
Reasonable cost "site licensing" available for student workbooks.
This is the first of two courses.