Lokhu kufundisa kuhlanganisa ukusebenzisa i-macro recorder ukudala i-macro elula ku- Excel . Isifundo asifihli ukudala noma ukuhlela i-macro usebenzisa umhleli we-VBA.
01 ka 05
Ukuqala i-Excel Macro Recorder
Qaphela: Ukuze uthole usizo kulezi zinyathelo, bhekisa esithombeni ngenhla.
Indlela elula yokwakha i-macro ku-Excel ukusebenzisa i-macro recorder.
Ukwenza kanjalo, chofoza Amathuluzi> Ama-Macros> Rekhoda i-New Macro emamenyu ukuze ukhiphe ibhokisi lengxoxo ye-Record Macro.
02 ka 05
Izinketho ze-Macro Recorder
Qaphela: Ukuze uthole usizo kulezi zinyathelo, bhekisa esithombeni ngenhla.
Kunezinketho ezine zokuqedela kuleli bhokisi lengxoxo:
- Igama - unike igama lakho elichazayo igama lakho.
- Ukhiye wezinqamuleli - (ngokuzithandela) gcwalisa incwadi esikhaleni esitholakalayo. Lokhu kuzokuvumela ukuba usebenze i-macro ngokubamba phansi ukhiye we-CTRL bese ucindezela incwadi ekhethiwe ekhibhodi.
- Londoloza ama-macro -
- Izinketho:
- ibhuku lamanje
- I-macro iyatholakala kuphela kuleli fayela.
- ibhuku lokusebenzela elisha
- Lolu khetho luvula ifayela elisha le-Excel. I-macro iyatholakala kuphela kuleli fayela elisha.
- incwadi yokusebenzela yama-macro.
- Le ndlela ikhiqiza ifayela elifihliwe - i-Personal.xls - elondoloza ama-macros akho bese yenza ukuba atholakale kuwe kuwo wonke amafayela we-Excel
- Incazelo - (okukhethwa kukho) Faka incazelo ye-macro.
03 ka 05
I-Excel Macro Recorder
Qaphela: Ukuze uthole usizo kulezi zinyathelo, bhekisa esithombeni ngenhla.
Uma usuqedile ukubeka izinketho zakho ebhokisini lezinkhulumomphendvulwano ze - Macro kwisinyathelo sangaphambilini salesi sifundo, chofoza inkinobho ye-OK ukuze uqale irekhodi le-macro.
Ibha yamathuluzi yokuqopha i-Stop Stop kufanele ivele futhi esikrinini.
Umrekhoda we-macro urekhoda zonke izinkinobho nokuchofoza kwegundane. Dala i-macro yakho ngu:
- ngesandla ngokusebenzisa zonke izinyathelo ezidingekayo.
- Uma usuqedile, chofoza inkinobho yokuma (isikwele esincane esibhakabhaka) kwibha yamathuluzi yokuqopha ye-Stop Recording .
- Uma ibha yamathuluzi yokuqopha ye-Stop ayitholakali, chofoza Amathuluzi> Ama-Macros> Yeka ukurekhoda kusuka kwamamenyu ukuyeka ukurekhoda.
04 ka 05
Ukuqalisa i-Macro ku-Excel
Qaphela: Ukuze uthole usizo kulezi zinyathelo, bhekisa esithombeni ngenhla.
Ukuqalisa i-macro orekhodile:
- Uma ukhethe ukhiye wezinqamuleli lapho udala i-macro, ubambe ukhiye we- CTRL kwikhibhodi bese ucindezela ukhiye wokushothikhathi.
Ngaphandle kwalokho,
- Chofoza Amathuluzi> Macros> Macro kusuka kwamamenyu ukuletha ibhokisi lezinkulumo ze - Macro .
- Khetha i-macro ohlwini lwalabo abatholakalayo.
- Chofoza inkinobho yokuqalisa.
05 ka 05
Ukuhlela i-Macro
Qaphela: Ukuze uthole usizo kulezi zinyathelo, bhekisa esithombeni ngenhla.
I-Excel macro ibhalwe ngolimi lwe-Visual Basic for Applications (VBA).
Ukuchofoza ku-Hlela noma Isinyathelo Kuzinkinobho ebhokisini lezinkulumo ze - Macro uqala umhleli we-VBA (bona isithombe esingenhla).
Amaphutha we-Macro
Ngaphandle kokuthi wazi i-VBA, ukurekhoda kabusha i-macro engasebenzi kahle ngokuvamile kuyindlela engcono kakhulu.