16 Corporate Woods Boulevard | Albany, New York 12211 | Tel: 518.437.1600

VBA Programming: Office 2010 Applications

Available Dates: Call for Availability
Class Length: 3 day
Cost: $1,275

Class Outline:

Course Outline:
Recording and Running Macros in the Office Applications
Getting Started with the Visual Basic Editor
Editing Recorded Macros
Creating Code from Scratch in the Visual Basic Editor
Understanding the Essentials of VBA Syntax
Working with Variables, Constants, and Enumerations
Using Array Variables
Finding the Objects, Methods, and Properties You Need
Using Built-in Functions
Creating Your Own Functions
Making Decisions in Your Code
Using Loops to Repeat Actions
Getting User Input with Message Boxes and Input Boxes
Creating Simple Custom Dialog Boxes
Creating Complex Dialog Boxes
Building Modular Code and Using Classes
Debugging Your Code and Handling Errors
Building Well-Behaved Code