VTC Legacy
Home / Business Applications

Forms, Macros and VBA

by Lauri Sowa
79 lessons15 chapters6.9 hReleased 2018Free course
Start the free chapter

Are you facing a repetitive clean-up of multiple contacts in Outlook? Are you overwhelmed by an influx of e-mail attachments that should be saved to your hard drive? Perhaps you need an electronic form to be completed or a survey. Automation and simplification of repetitive entries and formulas in MS Office is the answer. Learning how to automate formulas in Excel, forms in Word, and presentations in PowerPoint, can be accomplished with macros and Visual Basic for Applications (VBA).rnLauri Sowa Introduces non-programmers to some basic ways to use Macros, Forms, and VBA in Microsoft Office. Included is an overview of macros, snippets of code, and some key details about how to automate and design forms in Office applications, including simple programming examples.

Course content

Welcome4 lessons
Examples7 lessons
Introduction to Macros7 lessons
Microsoft Excel Automation and Routines5 lessons
Controls, Boxes & VBA Forms5 lessons
Automation Tools in Word6 lessons
MS Word Forms8 lessons
Commands and Macros for Word5 lessons
Visual Basics for Applications6 lessons
Creating a Function3 lessons
Microsoft Outlook8 lessons
Microsoft PowerPoint4 lessons
Microsoft Access6 lessons
Errors and Debugging3 lessons
Recap2 lessons