Lokhu kufundisa kuhlanganisa ukusebenzisa i-macro recorder ukudala i-macro elula ku- Excel . I-recorder macro isebenza ngokurekhoda zonke izinkinobho nokuchofoza kwegundane. I-macro edalwe kule tutorial izosebenzisa izinketho eziningi zokufometha esihlokweni sekhasi lokusebenzela .
Ku-Excel 2007 no-2010, yonke imiyalo ephathelene nokusebenzisana macro itholakala kuthebhu yonjiniyela yebhoni . Ngokuvamile, lethebhu idinga ukungezwa ku-ribbon ukuze ifinyelele imiyalo ye-macro. Izihloko ezihlanganiswe nalesi sifundo zihlanganisa:
- Ukungeza ithebhu yonjiniyela
- Ukuqala i-Excel macro recorder
- Izinketho ze-Excel macro recorder
- Ukurekhoda i-macro
- Ukuqalisa i-macro
- Amaphutha we-Macro / Ukuhlela i-macro
01 ka-06
Ukungeza ithebhu yonjiniyela
- Chofoza kuthebhu yefayela yebhebhoni ukuvula imenyu yefayela.
- Chofoza kuzinketho kwimenyu ukuvula ibhokisi lengxoxo ye- Excel .
- Cindezela inketho yeRibbon ngokwezifiso kwilawulwa ngakwesokunxele ukuze ubuke izinketho ezitholakalayo efasiteleni lesandla sokunene ebhokisini lengxoxo.
- Ngaphansi kwesigaba samathuluzi amakhulu okukhethwa kukho, iwindi lihlola inketho yoMthuthukisi.
- Chofoza OK.
- Ithebhu yonjiniyela kufanele manje ibonakale ku-Ribbon ku-Excel 2010.
Ukungeza ithebhu yonjiniyela ku-Excel 2007
- Ku-Excel 2007, chofoza inkinobho ye- Office ukuvula imenyu ehlayo.
- Chofoza inkinobho yezinketho ze-Excel ezitholakala ngaphansi kwemenyu ukuze uvule ibhokisi lengxoxo ye- Excel .
- Chofoza ku-Okukhethwa Okudumile phezulu kwewindi lesandla lesobunxele lebhokisi lengxoxo evulekile.
- Chofoza ku- Show Developer Tab ku-Ribbon ngakwesokudla kwesandla lebhokisi lengxoxo evulekile.
- Chofoza OK.
- Ithebhu yonjiniyela kufanele manje ibonakale ku-ribbon.
02 ka 06
Ukwengeza Isihloko Sokusebenzela / I-Excel Macro Recorder
Ngaphambi kokuba siqale ukurekhoda ama-macro ethu, sidinga ukwengeza isihloko sephepha lokusebenzela esizosifometha.
Njengoba isihloko sekhasi ngalinye lomsebenzi ngokuvamile lihlukile kulowo shicilelo, asifuni ukufaka isihloko esihlokweni. Ngakho-ke sizoyengeza ekhasini lokusebenzela, ngaphambi kokuqala i-recorder macro.
- Chofoza ku-cell A1 kushidi lokusebenzela.
- Thayipha isihloko: Izindleko zokuthenga ze-Cookie ngoJuni 2008 .
- Cindezela ukhiye wokungena kwikhibhodi.
I-Excel Macro Recorder
Indlela elula yokwakha i-macro ku-Excel ukusebenzisa i-macro recorder. Ukwenza kanjalo:
- Chofoza kuthebhu yonjiniyela .
- Chofoza ku-Rekhoda i-Macro ebhokisini ukuvula ibhokisi le- Record Macro .
03 ka 06
Izinketho ze-Macro Recorder
Kunezinketho ezingu-4 zokuqedela kuleli bhokisi lengxoxo:
- Igama le-macro - unike igama lakho elichazayo igama lakho. Igama kumele liqale ngencwadi kanye nezikhala azivunyelwe. Izinhlamvu kuphela, izinombolo kanye nomlingiswa wokugqashula kuvunyelwe.
- Ukhiye wezinqamuleli - (okukhethwa kukho) faka incwadi, inombolo, noma ezinye izinhlamvu endaweni ekhona. Lokhu kuzokuvumela ukuba usebenze i-macro ngokubamba phansi ukhiye we-CTRL bese ucindezela incwadi ekhethiwe ekhibhodi.
- Londoloza ama-macro
- Izinketho:
- Le ncwadi
- I-macro iyatholakala kuphela kuleli fayela.
- Ibhuku lokusebenzela elisha
- Lolu khetho luvula ifayela elisha le-Excel. I-macro iyatholakala kuphela kuleli fayela elisha.
- Ibhuku lomsebenzi lomuntu siqu.
- Le ndlela ikhiqiza ifayela elifihliwe Personal.xls eligcina ama-macros akho futhi lenze litholakale kuwe kuwo wonke amafayela we-Excel.
- Incazelo - (ngokuzikhethela) faka incazelo ye-macro.
Kule Nfundo
- Setha izinketho ebhokisini lengxoxo ye- Record Macro ukuze ufanise nalabo abasesithombeni ngenhla.
- Ungachofoli OK - okwamanje - bona ngezansi.
- Ukuchofoza inkinobho ye-OK ebhokisini lebhokisi le- Record Macro uqala ukurekhoda i-macro osuvele uyibonile.
- Njengoba kukhonjisiwe ngaphambili, i-recorder macro isebenza ngokurekhoda zonke izinkinobho nokuchofoza kwegundane.
- Ukwakha i- format_titles macro ihilela ukuchofoza izinketho eziningi zefomethi kuthebhu yasekhaya yebhebhoni negundane ngenkathi i-recorder macro isebenza.
- Iya kwisinyathelo esilandelayo ngaphambi kokuqala umrekhodi we-macro.
04 ka 06
Ukurekhoda izinyathelo ze-Macro
- Chofoza inkinobho e-OK ebhokisini lengxoxo ye- Record Macro ukuze uqale irekhodi le-macro.
- Chofoza kuthebhu yaseKhaya ye-ribbon.
- Gqamisa amaseli A1 kuya ku-F1 ekhasini lokusebenzela.
- Chofoza kusithonjana se- Merge ne-Centre ukubeka isihloko phakathi kwamaseli A1 no-F1.
- Chofoza ku-Isithonjana seMbala Yokugcwalisa (kubonakala sengathi upende ungakwazi) ukuvula uhlu lokudonsela phansi kombala ogcwala.
- Khetha i- Blue, i-Accent 1 ohlwini ukuze uguqule umbala wangemuva wamaseli akhethiwe ukuba abe okwesibhakabhaka.
- Chofoza kusithonjana sombala wefonti (yincwadi enkulu "A") ukuvula uhlu lwezintambo zokudonsa phansi.
- Khetha Okumhlophe ohlwini ukuze uvule umbhalo kumaseli akhethiwe ukuba abe mhlophe.
- Chofoza kusithonjana sefonti (ngaphezulu kwesithonjana sokudweba) ukuze uvule uhlu lwezintandokazi usayizi wefonti.
- Khetha okungu- 16 ohlwini ukuze ushintshe usayizi umbhalo kumaseli akhethiwe kuya amaphuzu angu-16.
- Chofoza kuthebhu yonjiniyela ye-Ribbon.
- Chofoza inkinobho Ye- Stop Recording ku-ribbon ukumisa ukurekhoda kwe-macro.
- Kuleli phuzu, isihloko sakho somsebenzi kufanele sifane nesihloko esithombeni esingenhla.
05 ka 06
Ukuqalisa i-Macro
Ukuqalisa i-macro orekhodile:
- Chofoza kuthebhu ye- Sheet2 phansi kwespredishithi .
- Chofoza ku-cell A1 kushidi lokusebenzela.
- Thayipha isihloko: Izindleko zokuthenga ze-Cookie ngoJulayi 2008 .
- Cindezela ukhiye wokungena kwikhibhodi.
- Chofoza kuthebhu yonjiniyela ye-Ribbon.
- Chofoza inkinobho ye- Macros ku-Ribbon ukuze ukhulise ibhokisi lebhokisi le- Macro le- View .
- Chofoza kwi- format_titles macro ewindini legama le- Macro .
- Chofoza inkinobho yokuqalisa.
- Izinyathelo ze-macro kufanele zigijime ngokuzenzekelayo futhi zisebenzise izinyathelo zokufometha ezifanayo ezisetshenziselwa isihloko eshidi 1.
- Kuleli qophelo, isihloko esiphezulu seshidi 2 kufanele sifane nesihloko ekhasini lokusebenzela 1.
06 ka-06
Amaphutha we-Macro / Ukuhlela i-Macro
Amaphutha we-Macro
Uma i-macro yakho ingenzi ngendlela elindelekile, indlela elula, futhi engcono kakhulu ukulandela izinyathelo zokufundisa futhi uphinde ubhale kabusha i-macro.
Ukuhlela / Isinyathelo Ku-Macro
I-Excel macro ibhalwe ngolimi lwe-Visual Basic for Applications (VBA).
Ukuchofoza ku- Hlela noma Isinyathelo ezinkinobho ebhokisini lebhokisi le- Macro uqala umhleli we-VBA (bona isithombe esingenhla).
Ukusebenzisa umhleli we-VBA nokumboza ulimi lohlelo lwe-VBA kungaphezu kwelokufundiswa.