ExcelＶＢＡクイズ講座 中級Ⅱ ユーザーフォーム

VBASYS塾

About this game

This is an intermediate-level quiz and tutorial for Excel VBA (Macro) User Forms.
Part 2 of the Intermediate Course Trilogy! (Part 1: Data Collection, Part 3: Access Integration)

The Excel versions tested in this course are:
Excel (Windows version) Microsoft 365, 2024-2007

■Exam Topics and Course Content■

The exam topics and course content cover the basics of user forms and a practical case study of the "Address Book" screens for adding, changing, deleting, and viewing.

Finally, you'll attempt a user form that integrates the new, change, delete, and view input modes.

■Quiz Questions■

Evaluation is based on a four-point scale:
100 points: Excellent.
80 points or less: Good.
60 points or less: Keep trying.
0 points or less: Keep trying.

Additionally, if you achieve a perfect score of 100 on all subjects, you will receive a certificate!

Only the certificate displayed in the app is official.

Try the quiz 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 at the intermediate level.

We recommend taking our "Excel VBA Intermediate Course: Data Calculation" beforehand.

= Basics =

1. Creating and Editing User Forms
2. Placing Controls
3. Properties Window
4. Event Procedures
5. UserForms Object
6. Common Controls

7 and beyond 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.

1. System Design and Processing Procedure 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.

What’s new

認定証の発行 (全課目１００点満点制覇!!の場合)
オプションメニューに[動画 (講座アプリ向け)]を追加
オプションメニューにアプリの[最新バージョンの確認]を追加
イメージトレーニングの画面の向きに応じてボタンの位置を変更
講座ページでのピンチ操作によるズームイン・ズームアウト機能に対応
Android 16 対応