Programming

Excel 2016/2013/2010 VBA Programming (2007 Upon Request)

This course covers the basics of Visual Basic for Applications (VBA) programming within Excel. Learn how to edit existing macros in VBA, automate common tasks by creating clickable command buttons and simplify data entry through user forms.

Dates & Times

CourseDate & TimeLocationCost
Excel 2016/2013/2010 VBA Programming (2007 Upon Request)March 1 - 8:30 - 4:30LathamRegister

Course Outline

Corporate and NYS discounts do not apply for this course.

This course is appropriate for individuals who need a better understanding of how to use Visual Basic within Excel or are looking to automate complex actions within their spreadsheets.

Includes:
Comprehensive reference manual with participant guide and exercises
Access to participant data files
Follow-up support by email or phone for an unlimited period

Lesson 1: Visual basic editor

  • Visual Basic for Applications
  • Object Programming
  • The Object Browser

Lesson 2: Programming basics

  • Data
  • Scope of variables
  • Scope of procedures

Lesson 3: Control structures

  • Decision structures
  • Loop structures

Lesson 4: Custom dialog boxes

  • User forms
  • Events

Lesson 5: Debugging and error-handling

  • Errors
  • Debugging
  • Error-handling