Visual Basic for Applications Level 1

Visual Basic for Applications Level 1
Visual Basic for Applications Level 1
Visual Basic for Applications Level 1
Visual Basic for Applications Level 1
Visual Basic for Applications Level 1
Visual Basic for Applications Level 1
Visual Basic for Applications Level 1
Visual Basic for Applications Level 1
Product Rating
File Type

PDF (Acrobat) Document File

Be sure that you have an application to open this file type before downloading and/or purchasing.

1 MB|61 pages
Share
Product Description
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.
Total Pages
61 pages
Answer Key
N/A
Teaching Duration
2 days
Report this Resource
Loading...
$39.95
Digital Download
avatar

Prof Skip

5 Followers
Follow
More products from Prof Skip
Product Thumbnail
$0.00
Product Thumbnail
$0.00
Product Thumbnail
$0.00
Product Thumbnail
$0.00
Product Thumbnail
$0.00
$39.95
Digital Download
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign up