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

VBASYS塾

Mayelana nale geyimu

Lona umbuzo wezinga elimaphakathi kanye nesifundo se-Excel VBA (Macro) Amafomu Omsebenzisi.
Ingxenye 2 ye-Intermediate Course Trilogy! (Ingxenye 1: Ukuqoqwa Kwedatha, Ingxenye 3: Ukuhlanganiswa Kokufinyelela)

Izinguqulo ze-Excel ezihlolwe kulesi sifundo yilezi:
I-Excel (inguqulo ye-Windows) Microsoft 365, 2024-2007

■ Izihloko Zesivivinyo Nokuqukethwe Kwezifundo■

Izihloko zokuhlolwa nokuqukethwe kwesifundo kuhlanganisa izisekelo zamafomu omsebenzisi kanye nesifundo sesibonelo esisebenzayo sezikrini "zencwadi yamakheli" ukuze kwengezwe, kushintshwe, kususwe, futhi kubukwe.

Ekugcineni, uzozama ifomu lomsebenzisi elihlanganisa okusha, ukushintsha, ukususa, nokubuka izindlela zokufaka.

■ Imibuzo Yemibuzo■

Ukuhlola kusekelwe esikalini samaphuzu amane:
Amaphuzu ayi-100: Kuhle kakhulu.
Amaphuzu angama-80 noma ngaphansi: Kuhle.
60 amaphuzu noma ngaphansi: Qhubeka uzama.
0 amaphuzu noma ngaphansi: Qhubeka uzame.

Ukwengeza, uma uzuza amaphuzu aphelele angu-100 kuzo zonke izifundo, uzothola isitifiketi!

Isitifiketi esivezwe kuhlelo lokusebenza kuphela esisemthethweni.

Zama imibuzo ukuze uzuze isitifiketi sakho!

■ Uhlolojikelele lwesifundo■

(Inkomba)
Lesi sifundo sigxile kakhulu kumafomu omsebenzisi, ngakho-ke sithatha ngokuthi usuvele uwazi kahle ikharikhulamu edingekayo ezingeni elimaphakathi.

Sincoma ukuthatha i-"Excel VBA Intermediate Course: Data Calculation" kusengaphambili.

= Izisekelo =

1. Ukudala nokuhlela Amafomu Omsebenzisi
2. Ukubeka Izilawuli
3. Iwindi Lezakhiwo
4. Izinqubo Zomcimbi
5. Umsebenzi Wamafomula
6. Izilawuli Ezivamile

7 nangaphezulu izilawuli eziyinhloko.

7. Ukulawula Ilebula
8. Ukulawula Ibhokisi Lombhalo
9. ListBox Control
10. ComboBox Control
11. Ukulawula Ibhokisi Lokuhlola
12. OptionButton Control
13. Ukulawula Uhlaka
14. I-CommandButton Control
15. Ukulawula Isithombe

= Isifundo Esisebenzayo =

Njengesibonelo, sizosebenzisa ithuluzi lakudala lokufaka idatha, "Incwadi Yamakheli," futhi siqhubeke nenqubo kusukela ekufakeni idatha ngefomu lokufaka ukuya ekuyibhaliseni kufayela ledatha. Lesi sifundo sizofaka nedatha yesithombe.

1. Idizayini Yesistimu kanye Nenqubo Yokucubungula Yefomu Lomsebenzisi elithi "Incwadi Yamakheli".

2. Ukudala kanye Nokufaka Ikhodi Amafomu Omsebenzisi Okubhaliswa Okusha, Ukushintsha, kanye Nokususa Izikrini

3. Ukuhlanganiswa Kwesistimu Engaphansi Kwefomu Lomsebenzisi elithi "Incwadi Yamakheli".
Izikrini ezintsha zokubhalisa, ukushintsha, nokususa kuzohlanganiswa kusistimu eyodwa.

4. Ukudala kanye Nokufaka Ikhodi Ifomu Lomsebenzisi Lesikrini Sokubuka
Kwezinye izimo, ukukwazi nje ukubuka idatha kwanele, ngakho-ke sizocabangela futhi sakhe isikrini sokubuka.

5. Ukuhlanganisa Imodi Yokufaka Yefomu Lomsebenzisi elithi "Incwadi Yekheli".
Sizohlanganisa ukubhaliswa okusha, sihlele, sisuse, futhi sibuke izikrini sibe ifomu lomsebenzisi oyedwa.

Yini entsha

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