Welcome to the new NAIT.ca! We encourage you to explore the site and provide your feedback.

Continuing Education

CCTO446 - Creating User Forms in Excel VBA

Course Code

A unique identifier used at NAIT for this specific course.

Campus

The location where your NAIT courses will be held.

Course Overview

The focus of this course is this course is to create custom forms. Students will learn how to create the form, work with various controls such as labels, text boxes, option buttons, checkboxes, list boxes, and command buttons. Students will learn about Event Driven programming where actions performed by users and events trigger code to run. Specifically, the Initialize, Change, KeyPress, KeyDown, Enter, Exit, BeforeUpdate, AfterUpdate, and Click events will be explored. The Introduction to Excel VBA or previous programming experience is required to take this course.

Recommended: CCTO445 Introduction to Excel VBA

Upcoming Offerings

Filter by Terms:
Section Start/End Schedule
A01 Nov. 27 - Nov. 28, 2019 Wed, Thu
Hours Delivery Fees
14 hours Day $450
Meeting Times:
  • Nov. 27 & 28 - Wednesday, Thursday: 8:00 AM - 3:50 PM

Section Start/End Schedule
E01 Jan. 17 - Jan. 19, 2020 Fri, Sat, Sun
Hours Delivery Fees
14 hours Day, Evening $450
Meeting Times:
  • Jan. 17 - Friday: 6:00 PM - 9:50 PM
  • Jan. 18 - Saturday: 8:00 AM - 3:50 PM
  • Jan. 19 - Sunday: 8:00 AM - 11:50 AM

Section Start/End Schedule
E01 May. 08 - May. 10, 2020 Fri, Sat, Sun
Hours Delivery Fees
14 hours Day, Evening $450
Meeting Times:
  • May. 8 - Friday: 6:00 PM - 9:50 PM
  • May. 9 - Saturday: 8:00 AM - 3:50 PM
  • May. 10 - Sunday: 8:00 AM - 11:50 AM

*Day delivery ranges between 8 AM - 5 PM.
**Evening delivery ranges between 5 PM - 10 PM.