User Forms (PPT)
Introduction to User Forms
ComboBox
List Box
Option Buttons
Check Boxes
Spin Buttons
Toggle Buttons
User Form Pictures
Readings
User Form Object (Microsoft Documentation)
Using ActiveX Controls on a Document (Microsoft Docmentation)
Practice User Forms on your own with these exercises
Exercise 1: Solution 1
Exercise 2: Solution 2
Practice User Forms on your own with these exercises
Exercise 1: Solution 1
Exercise 2: Solution 2
--- OPTIONAL MATERIALS ---
Error Handling
VBA Error Handling
Readings
On Error Statement (Microsoft Documentation)
VBA Error Handling - A Complete Guide
Avoid Using Global Variables
Scope of Variables
Readings
Declaring Variables (Microsoft Documentation)
Understanding the Lifetime of Variables (Microsoft Documentation)
Error Handling
VBA Error Handling
Readings
On Error Statement (Microsoft Documentation)
VBA Error Handling - A Complete Guide
Avoid Using Global Variables
Scope of Variables
Readings
Declaring Variables (Microsoft Documentation)
Understanding the Lifetime of Variables (Microsoft Documentation)