RegisterSign In

VBA Programming

ProTrain Online

Description

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.

Objectives

  • 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.

Outcomes

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.

Assessment

course quick facts
course code PRO2075
cost $375.00
estimated time to
complete course
32 Hours
course materials
available
7 Weeks