Visual Basic for Applications (VBA) Student Courseware Level 1

Visual Basic for Applications (VBA) Student Courseware Level 1
Visual Basic for Applications (VBA) Student Courseware Level 1
Visual Basic for Applications (VBA) Student Courseware Level 1
Visual Basic for Applications (VBA) Student Courseware Level 1
Visual Basic for Applications (VBA) Student Courseware Level 1
Visual Basic for Applications (VBA) Student Courseware Level 1
Visual Basic for Applications (VBA) Student Courseware Level 1
Visual Basic for Applications (VBA) Student Courseware Level 1
Product Rating
File Type

Compressed Zip File

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

1 MB|67 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 student workbook is to be used as courseware for an instructor led 10 - 14 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 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
67 pages
Answer Key
N/A
Teaching Duration
2 days
Report this Resource
Loading...
$39.95
Digital Download
avatar

Prof Skip

19 Followers
Follow
More products from Prof Skip
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
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