VTC Legacy
Home / Programming

Microsoft Visual Basic for Applications (VBA)

by Robert Ekblaw
80 lessons11 chapters7.4 hReleased 20124 free
Start the free chapter

The Microsoft Office suite of applications (Word, Excel, PowerPoint, and Access) allows users to customize views or output, but the processing performed by the applications cannot be changed. However, Microsoft provides an interface in which the user can create customized processing. The language used for this customized processing is based on a computer programming language called Visual Basic. The Microsoft programming environment, called Visual Basic for Applications, has a special format and syntax that must be followed in order for the computer to properly perform the work. This VTC course describes the reserved keywords, structures, and language aspects that a user would need to know in order to create customized processing for Microsoft Office applications. Work Files are included. To begin learning today, simply click on the movie links.

Course content

Introduction4 lessons
Data and Variables13 lessons
Using Macros6 lessons
VBA Expressions15 lessons
Dialog Boxes5 lessons
Functions and Procedures7 lessons
Conditional Processing10 lessons
Loops12 lessons
Testing Your Work5 lessons
Conclusion2 lessons
Credits1 lessons