Ama-macros e-Excel: ayini nokuthi asetshenziswa kanjani

Uma unochungechunge olulula lwezenzo okudingeka uluphinde izikhathi eziningi, ungaba ne-Excel ukurekhoda lezi zenzo futhi ukhiqize i-macro equkethe ikhodi ukuze uziphinde.

Uma usuqophe i-macro, ungaphinda uchungechunge lwezenzo izikhathi eziningi ngokuthanda kwakho, ngokusebenzisa nje imakhro erekhodiwe. 

Lokhu kusebenza kahle kakhulu kunokuphinda ngokwenza uchungechunge olufanayo lwezenzo isikhathi ngasinye.

Ukuze urekhode imakhro kufanele uqale inqubo yokuqopha. Le nketho itholakala kumenyu I-Macro , etholakala kuthebhu Buka kuribhoni ye-Excel (noma kumenyu a ukwehla Amathuluzi ku-Excel 2003). Lezi zinketho ziboniswa ezithombeni ezingezansi:

Rekhoda ama-macros ezinguqulweni zamanje ze-Excel (2007 nakamuva):

Ngemuva kwalokho uzokwethulwa ngebhokisi lengxoxo elithi “Rekhoda Macro”. 

Leli bhokisi likuvumela ukuthi ufake igama nencazelo ye-macro yakho, uma uthanda. Kungumqondo omuhle ukunikeza i-macro igama elinengqondo, ukuze kuthi lapho ubuyela ku-macro kamuva, lokhu kuzokusiza ukhumbule ukuthi yenzani. Kodwa-ke, uma unganikezi igama, i-Excel izoqamba ngokuzenzakalelayo i-macro (isb. Macro1, Macro2, njll.).

Ibhokisi lengxoxo elithi "Rekhoda Macro" liphinde linikeze inketho yokwabela isinqamuleli sekhibhodi kumakhro akho. Lokhu kuzokwenza kube lula kakhulu ukusebenzisa i-macro. Kodwa-ke, kufanele uqaphele ukuthi unganiki enye yezinhlanganisela zokhiye wangaphambili ku-macrodefii-Excel (isb. CTRL-C). Uma ukhetha inhlanganisela yokhiye we-Excel ekhona, izobhalwa ngaphezulu yi-macro yakho, futhi wena noma abanye abasebenzisi ningagcina nisebenzise ikhodi enkulu ngephutha.

Uma usujabule ngegama elikhulu kanye (uma kunesidingo) nesinqamuleli sekhibhodi, khetha okuthi KULUNGILE ukuze uqale ukurekhoda imakhro.

Uma usuqalile ukurekhoda i-macro yakho, zonke izenzo ozenzayo (ukufaka idatha, ukukhetha iseli, ukufometha kwamaseli, ukuskrola kwamakhasi okusebenza, njll.) kuzorekhodwa kumakhro entsha, njengekhodi ye-VBA.

Ukwengeza, njengoba uqopha i-macro yakho, uzobona inkinobho yokumisa ngezansi kwesokunxele sebhuku lakho lokusebenza (noma ku-Excel 2003, inkinobho yokumisa izokwethulwa kubha yamathuluzi entantayo), njengoba kukhonjisiwe ngezansi:

Uma usuqedele izenzo ofuna ukuzirekhoda, ungayeka ukurekhoda imakhro ngokuchofoza inkinobho ethi Misa. Ikhodi ye-macro manje izogcinwa kumojula ngaphakathi komhleli we-Visual Basic.

Inketho ethi 'Sebenzisa izithenjwa ezihlobene'

Uma ukhetha inketho Sebenzisa izinkomba ezihlobene Lapho urekhoda i-macro, zonke izinkomba zeseli ngaphakathi kwe-macro zizohlobana. Nokho, uma inketho Sebenzisa izinkomba ezihlobene ayikhethiwe, zonke izinkomba zeseli ezivezwe kukhodi zizobe ziphelele (bona okuthunyelwe kwethu ku ama-reference operators).

Inketho Sebenzisa izinkomba ezihlobene itholakala kumenyu I-Macro (futhi itholakala kubha yamathuluzi ye-Macro ku-Excel 2003). 

Isebenzisa amamakhro arekhodiwe

Lapho urekhoda ama-macros, i-Excel ihlala ikhiqiza inqubo engaphansi (kunokuba inqubo Yomsebenzi). Uma unikeze isinqamuleli sekhibhodi kumakhro, lesi sinqamuleli sizoba indlela elula yokusebenzisa i-macro. Uma kungenjalo, i-macro ingaqhutshwa ngokwenza lezi zinyathelo ezilandelayo:

• Cindezela u-Alt + F8 (okungukuthi cindezela ukhiye we-ALT futhi ngenkathi ucindezelwa, cindezela u-F8) ukuze ubonise ibhokisi lengxoxo elithi 'Macros';
• Ebhokisini lengxoxo elithi “Macro”, khetha i-macro ofuna ukuyisebenzisa;
• Ukuchofoza su Gijima .

Ercole Palmeri