Okulandelayo, sizokufundisa ungenza kanjani ama-macros aveleleUma ungathanda ukwazi ukuthi ungakwenza kanjani lokhu kalula futhi ngokushesha? sincoma ukuthi uqhubeke ufunda.
Funda ungenza kanjani ama-macros avelele.
Ungawenza kanjani ama-macros ku-Excel? Igxathu emvakwe gxathu
Uma usebenzisa i-Excel njalo, amathuba ukuthi usuvele ukhombe imisebenzi eyinkimbinkimbi okudingeka uyenze. Kuyinkimbinkimbi ukuze kufanele uqoqe izinyathelo eziningana zilandelana, njenge:
Hlunga imali engenayo yokuthengisa bese uyiguqulela eshadini, shintsha imibala kunhlokweni, futhi usebenzise amafomula ahlukile kusethi yamaseli.
AmaMacros enzelwa ukonga isikhathi nokwenza imisebenzi esiyenzayo ilandelane. Uma usuvele uyazi ukuthi yiziphi lezi zenzo ezintathu noma ezine ohlale uzisebenzisa, ngendlela efanayo ungakuguqula lokhu kube yi-macro, okungukuthi, i-oda elinikwa amandla ngaso sonke isikhathi lapho ucindezela izinkinobho eziningana futhi wenza imisebenzi eminingana ngokuzenzakalela.
/ Ungayakha kanjani futhi uyiqhube iMacro ku-Excel?
Into yokuqala okufanele uyenze ukuvula i-Excel, vula ishidi elingenalutho bese ufaka ithebhu ethi "Buka" bese uhlola ukuthi ngabe isithonjana se- "Macros" sikhona yini. Uma ingaveli, kufanele uye ku- "Ifayela", bese uya engxenyeni ethi "Izinketho" bese kuthi lapho ithi "Yenza ngokwezifiso iRibhoni", lapha kufanele unike amandla isithonjana se- "Macro" ukuze sivele ku- "Buka".
Ukwakha ukurekhoda okukhulu, konke okumele ukwenze cindezela isithonjana se- «Macro», faka amamenyu bese ubhala konke ngokuya ngokuthi kunikezwe kanjani inhlanganisela yezinkinobho ezingaba yi- «Control + key» ofuna ukumisa, khumbula ukukhetha inhlanganisela yokhiye bezenzo, futhi uma sezirekhodwe zizophindaphindwa njalo lapho uzisebenzisa, njenge:
Uma uzokwakha i-macro elula, kufanele ungeze isihloko eshidini elingenalutho, kumakholomu angaba "Isifinyezo sosuku, izindleko zokuthengisa kanye nengqikithi", futhi ama-macros asetshenziswa ezenzweni eziyinkimbinkimbi, noma kunjalo , uma sisebenzisa lesi sibonelo esilula singaqondakala kangcono.
Futhi kuthebhu ethi "Buka" kufanele uthole inketho ye- "Macros" futhi uma leyo menyu isivuliwe, kufanele ukhethe u- "Record macros", kufanele unikeze le Macro igama, ngaphandle kwezikhala. Bese kusigaba "sokhiye wesinqamuleli" kufanele ukhombise ukhiye ozokwenza le macro isebenze, njenge- "Control + R". Khumbula ukungasebenzisi okhiye abasebenzisa iWindows ukwenza eminye imisebenzi efana ne- "Control + C" ukukopisha umbhalo.
Ngemuva kwalokho ku- "Incazelo" kufanele uchaze, yenzelwa ini le Macro? Uma uchofoza ku- "KULUNGILE", ukuqoshwa kwe-macro kuzoqala, uzobona ukuthi lokhu kuzoba njalo ngoba inkinobho yokuqopha izovela engxenyeni engezansi kwesobunxele ye-Excel. Ukusuka lapha, noma yisiphi isenzo osenzayo sizorekhodwa ngaphakathi kwemacro.
Ukubuyela esibonelweni, uzongeza isihloko njengoba besishilo "Isifinyezo sosuku, ukuthengisa, izindleko kanye nenani eliphelele", ngesizinda kanye nohlamvu lwemibala ehlukene, ngemuva kwalokhu uzocindezela inkinobho yokuqopha enkulu ukumisa ukurekhoda, futhi usuqedile. udale imakhro ukuze ukwazi ukugcina ibhuku lokusebenzela le-Excel futhi uma uligcina kubalulekile ukuthi ukhethe ibhokisi elithi "Thayipha" kanye nenketho ethi "ibhuku lokusebenzela le-Excel elinikwe amandla ama-macros", uma ungakwenzi, i-macro ayisebenzi.
Manje usungayisebenzisa le macro kunoma iyiphi incwadi ngale ndlela elandelayo: Uvula ishidi elingenalutho futhi uma ucindezela i- «Alt + F8», uhlu lwama-macros owalondolozile luzovuleka, bese uzokhetha leyo ofuna ukuyisebenzisa futhi chofoza ku- «Execute» futhi ngale ndlela ukuqoshwa kwe-macro kuzongezwa ngokuzenzakalela. Ungayisebenzisa futhi ngezinkinobho ozinikeze njengo- "Control + R".
Uma lolu lwazi belusizo, unganqikazi ukuvakashela iwebhusayithi yethu, lapho uzothola khona izindatshana ezinjengalezi: Ungenza kanjani ikhalenda eZwini Igxathu emvakwe gxathu?