Microsoft Excel VBA/Macro Programming

Microsoft Excel Macro Programming

This ILT Series course is designed to give experienced Excel users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.


Prerequisites

To be successful in this course, students should have completed Microsoft® Office Excel®: Part 1, Part 2 and/or Part 3 in preparation for this course.

Lesson Contents

  • Visual Basic for Applications
  • Object programming
  • The Object Browser
  • Data basics
  • Scope of variables
  • Scope of procedures
  • Decision structures
  • Loop structures
  • User forms
  • Events
  • Errors
  • Debugging
  • Error handling

$159

8:30 am - 4:30 pm
Lunch is on your own
11:30 am - 12:30 pm

10% discount for University of Arkansas Faculty, Staff, Current Students, and Alumni Association Members. Status will be verified and the appropriate rate will be applied.


Schedule

This course is not yet scheduled, but we can notify you when it is.

Send Me Updates