This is a quiz and tutorial on intermediate-level user forms using VBA macros in Microsoft Excel, a major spreadsheet software that runs on Windows.
This is the second part of a three-part intermediate course. (Part 1: Data Collection, Part 3: Database Integration)

This course covers Excel versions 365, 2024-2007.

(Trademark Information)
Microsoft Excel is a registered trademark or trademark of Microsoft Corporation in the United States and/or other countries.
VBA (Visual Basic for Applications) and Visual Basic are registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries.

■Question Scope and Course Content■

In the Basics section, you will learn basic knowledge and know-how about user forms.
In the Practical section, you will learn the new registration, change, deletion, and viewing screens of an "Address Book" as a case study.
Finally, you will attempt to create a user form that integrates new, change, delete, and view input modes.

■Quiz■

Evaluation will be based on the following four levels:
100 points: Very good.
80 points or less: Good job.
60 points or less: Keep trying.
0 points or less: Try harder.

Achieving a perfect score of 100 points on all subjects will result in a certificate!
Only the certificate displayed in the app is official.
Try our quiz questions to earn your [certificate]!

■Course Overview■

(Reference)
This course focuses primarily on user forms, so it assumes that you have already mastered the necessary curriculum for the intermediate level.
We recommend taking our "Intermediate Course: Data Collection" beforehand.

= Basics =
1. Creating and Editing User Forms
2. Placing Controls
3. Properties Window
4. Event Procedures
5. UserForms Objects
6. Common Control Items

The following are the main controls.
7. Label Control
8. TextBox Control
9. ListBox Control
10. ComboBox Control
11. CheckBox Control
12. OptionButton Control
13. Frame Control
14. CommandButton Control
15. Image Control

= Practical Lesson =
As a case study, we will use the classic data entry tool, "Address Book," and walk through the process from entering data in an input form to registering it in a data file. This lesson will also cover image data.

Lesson Steps:

1. System Design and Processing Procedure Consideration for the "Address Book" User Form

2. Creating and Coding User Forms for the New Registration, Change, and Delete Screens

3. Subsystem Integration for the "Address Book" User Form
The new registration, change, and delete screens will be integrated into a single system.

4. Creating and Coding a User Form for the View Screen
In some cases, just being able to view the data is enough, so we'll consider and create a view screen.

5. Integrating the Input Mode for the "Address Book" User Form
We'll integrate the new registration, edit, delete, and view screens into a single user form.