Visual Basic for Applications Level 2

Visual Basic for Applications Level 2
Visual Basic for Applications Level 2
Visual Basic for Applications Level 2
Visual Basic for Applications Level 2
Visual Basic for Applications Level 2
Visual Basic for Applications Level 2
Visual Basic for Applications Level 2
Visual Basic for Applications Level 2
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|69 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 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.
Total Pages
69 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