Mastering VBA for Microsoft® Office 2016
CLASS DATE(s):
7/20/2020 - 7/22/2020
9/21/2020 - 9/23/2020

COURSE LENGTH: 3 Days

COURSE COST: $1195.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print
Register for this course
register

COURSE OVERVIEW

Visual Basic for Applications (VBA) is a powerful tool that enables you to automate tasks in Microsoft Office applications.

Automating can save you and your colleagues considerable time and effort. Getting more work done in less time is usually good for your self-esteem, and it can do wonderful things for your job security and your career.

AUDIENCE AND PREREQUISITES

FOLLOW UP COURSES  

*Course cost listed does not include the cost of courseware or lunch. Course is subject to minimum enrollment. Please contact us at learn@vtec.org or 207-775-0244 for additional pricing information, or if you have any questions.

COURSE TOPICS:


Module 1: Recording and Running Macros in the Office Applications

Module 2: Getting Started with the Visual Basic Editor

Module 3: Editing Recorded Macros

Module 4: Creating Code from Scratch in the Visual Basic Editor

Module 5: Understanding the Essentials of VBA Syntax

Module 6: Working with Variables, Constants, and Enumerations

Module 7: Using Array Variables

Module 8: Finding the Objects, Methods, and Properties You Need

Module 9: Using Built-In Functions

Module 10: Creating Your Own Functions

Module 11: Making Decisions in Your Code

Module 12: Using Loops to Repeat Actions

Module 13: Getting User Input with Message Boxes and Input Boxes

Module 14: Creating Simple Custom Dialog Boxes

Module 15: Creating Complex Forms

Module 16: Building Modular Code and Using Classes

Module 17: Debugging Your Code and Handling Errors

Module 18: Building Well-Behaved Code

Module 19: Exploring VBA’s Security Features

Module 20: Understanding the Word Object Model and Key Objects

Module 21: Working with Widely Used Objects in Word

Module 22: Understanding the Excel Object Model and Key Objects

Module 23: Working with Widely Used Objects in Excel

Module 24: Understanding the PowerPoint Object Model and Key Objects

Module 25: Working with Shapes and Running Slide Shows