VBA Programming

Hours: 32 / Access Length: 7 Weeks / Delivery: Monthly, Mentor Supported
Retail Price: $375.00

Course Overview:

This course will introduce students who are familiar with Word, Excel or Access the basics of writing and debugging VBA code. VBA is Microsoft's Visual Basic for Application and is the tool used to create custom macros and user-interfaces in the Office applications. Students will learn to define variables, create loops and branching statements, define functions, get user input and interface with the application of their choice. Students will need a copy of Microsoft Word, Excel or Access. A 30-day trial is available.

ATTENTION: This course has a strict start and end date.  When a student enrolls into this course, they will need to work with one of our Training Assessment Managers (TAMs) to choose a start date before they can be enrolled in their course.

Course Outline:

• Students will record macros and use the VBA editor to view and edit them.
• Students will use the VBA to create macros.
• Students will write VBA code which uses arrays.
• Students will write VBA code to work with objects, methods and properties.
• Students will write VBA code to define and use functions.
• Student will write VBA code which uses use decision and loops statements.
• Students will write VBA code which uses message boxes and input boxes.
• Students will design and use dialog boxes in their VBA applications.
• Students will write code to handle errors and use the debugging tools to find errors in their code.
• Students will create a final project to show what they have learned in this course.

All necessary materials are included.

System Requirements:

• Cable and DSL internet connections are recommended for the best experience.

• CPU: 1 GHz or higher
• RAM: 2 GB or higher
• Resolution: 1280 x 720 or higher
• Speakers / Headphones
• Microphone (Webinar / Live Online sessions)

• Microsoft Windows 7 or 10 (Home, Pro)
• Mac OSX 10 or higher.
• Latest Chrome OS
• Latest Linux Distributions

NOTE: While we understand that our courses can be viewed on Android and iPhone devices, we do not recommend the use of these devices for our courses. The size of these devices do not provide a good learning environment for students taking online or live online based courses.

• Latest Google Chrome is recommended for the best experience.
• Latest Mozilla FireFox
• Latest Microsoft Edge
• Latest Apple Safari

• Office suite software (Microsoft Office, OpenOffice, or LibreOffice)
• PDF reader program (Adobe Reader, FoxIt)
• Courses may require other software that is denoted in the above course outline.