Amafomu Okungena Kwedatha kwiMicrosoft Excel

Ukwenza lula ukufaka idatha etafuleni ku-Excel, ungasebenzisa amafomu akhethekile ukusiza ukusheshisa inqubo yokugcwalisa uhla lwethebula ngolwazi. I-Excel inethuluzi elakhelwe ngaphakathi likuvumela ukuthi ugcwalise ngendlela efanayo. Umsebenzisi angakha futhi uhlobo lwayo lwefomu, oluzoguqulwa ngokwezidingo zakhe, esebenzisa i-macro yalokhu. Ake sibheke ukusetshenziswa okuhlukile kwalawa mathuluzi okugcwalisa awusizo ku-Excel.

Usebenzisa amathuluzi okugcwalisa

Ifomu lokugcwalisa liyinto enamasimu amagama wawo ahambelana namagama wekholomu yetafula okufanele agcwaliswe. Udinga ukufaka idatha kulezi zinkambu futhi zizongezwa ngokushesha ngumugqa omusha kububanzi bethebula. Ifomu lingasebenza njengethuluzi le-Excel elakhelwe ngaphakathi, noma libekwe ngqo eshidi ngesimo sobubanzi balo, uma lakhiwa umsebenzisi.

Manje ake sibheke ukuthi ungazisebenzisa kanjani lezi zinhlobo ezimbili zamathuluzi.

Indlela yoku-1: into eyakhelwe ngaphakathi kokufaka idatha ye-Excel

Okokuqala, ake sifunde ukusebenzisa ifomu elakhelwe ukufaka idatha ye-Excel.

1. Kufanele kwaziwe ukuthi ngokuzenzakalela isithonjana esisungula sifihlekile futhi sidinga ukwenziwa ukuthi sisebenze. Ukuze wenze lokhu, iya kuthebhu Ifayelabese uqhafaza entweni "Izinketho".



2. Ewindini lezinketho le-Excel elivuliwe, dlulela esigabeni Ithuluzi Lokufinyelela Esheshayo. Iningi lewindi lihlala indawo ebanzi yezilungiselelo. Ngakwesobunxele kukhona amathuluzi angangezwa kuphaneli yokufinyelela okusheshayo, ngakwesokunene - osevele ekhona.

   Ensimini "Khetha amaqembu kusuka" inani elisethiwe "Amaqembu awekho kwiteyipu". Okulandelayo, kusuka kuhlu lwemiyalo ngokulandelana kwama-alfabhethi, sithola bese sikhetha isikhundla "Ifomu ...". Bese uchofoza inkinobho Faka.



3. Ngemuva kwalokho, ithuluzi esilidingayo lizokhonjiswa ngakwesokunene sewindi. Chofoza inkinobho "Kulungile".



4. Manje leli thuluzi selisewindows le-Excel kufasitela lokungena ngokushesha, futhi singalisebenzisa. Kuzoba khona lapho kuvulwa noma iyiphi incwadi yokusebenza ngalesi sibonelo se-Excel.



5. Manje, ukuze ithuluzi liqonde ukuthi yini ngempela okudingeka ligcwaliswe, kufanele ugcwalise izihloko zethebula bese ubhala noma iliphi inani elikulo. Ukuhlelwa kwetafula nathi kufanele kube nezinsika ezine ezinamagama "Igama lomkhiqizo", "Ubuningi", "Intengo" futhi "Inani". Faka idatha yegama ebangeni le-sheet eliyindilinga.



6. Futhi, ukuze uhlelo luqonde ukuthi yiluphi umugqa oluzodinga ukusebenzisana nalo, kufanele ufake noma iliphi inani kumugqa wokuqala wokuhlelwa kwetafula.



7. Ngemuva kwalokho, khetha noma isiphi iseli lethebula elingenalutho bese uchofoza isithonjana kuphaneli yokufinyelela okusheshayo "Ifomu ..."esake sasebenza ngawo ngaphambili.



8. Ngakho-ke, iwindows yethuluzi elicacisiwe liyavula. Njengoba ukwazi ukubona, le nto inezindimu ezihambelana namagama wekholomu wokuhlelwa kwetafula lethu. Ngaphezu kwalokho, inkambu yokuqala isivele igcwele inani, ngoba sayifaka ngesandla eshidini.



9. Faka amanani abona ukuthi ayadingeka emasimini asele, bese uchofoza inkinobho Faka.



10. Ngemuva kwalokho, njengoba ubona, amanani afakiwe adluliselwa ngokuzenzakalela kumugqa wokuqala wetafula, futhi esimeni lapho kwaba nokuguqukela ebhulini elilandelayo lezinkambu, elihambelana nomugqa wesibili wokuhlelwa kwetafula.



11. Gcwalisa iwindi lamathuluzi ngamanani esifuna ukuwabona emugqeni wesibili wendawo yetafula, bese uqhafaza inkinobho futhi Faka.



12. Njengoba ubona, amanani entambo yesibili afakiwe futhi, futhi asizange futhi sazihlelele kabusha i-isikhombisi etafuleni uqobo.



13. Ngakho-ke, sigcwalisa uhlu lwethebula ngawo wonke amagugu esifuna ukungena kuwo.



14. Ngaphezu kwalokho, uma kufiswa, ungadabula amanani afakwe ngaphambili usebenzisa izinkinobho "Buyela" futhi "Okulandelayo" noma ibha yokuqonda mpo.



15. Uma kunesidingo, ungaguqula noma iliphi inani kumalungu etafula ngokulishintsha ngendlela. Ukuze wenze ushintsho olukhonjiswe eshidini, ngemuva kokulenza libhlokile elihambisanayo lethuluzi, chofoza inkinobho Faka.



16. Njengoba ubona, ushintsho lwenzeka ngokushesha endaweni yetafula.



17. Uma sidinga ukususa umugqa, khona-ke ngokusebenzisa izinkinobho zokuhambisa noma ibha yokuhambisa siye kwibhloko yensimu elihambisanayo efomu. Ngemuva kwalokho chofoza inkinobho Susa ewindini lamathuluzi.



18. Ingxoxo yokuxwayisa iyavula, ikwazise ukuthi ulayini uzosuswa. Uma uqiniseka ngezenzo zakho, bese uchofoza inkinobho "Kulungile".



19. Njengoba ubona, umugqa ukhishwe ebangeni lethebula. Ngemuva kokuthi ukugcwalisa nokuhlela kuqediwe, ungaphuma iwindi lamathuluzi ngokuchofoza inkinobho Vala.



20. Ngemuva kwalokho, ukunikeza itafula ukuhlelwa kokubukeka okubonakalayo okubonakalayo, ukufometha kungenziwa.

Indlela 2: yakha ifomu elenzelwe lona

Ngaphezu kwalokho, ngosizo lwe-macro nenqwaba yamanye amathuluzi, kungenzeka ukuthi uzenzele owakho amafomu okugcwalisa indawo yetafula. Izokwakhiwa ngokuqondile eshidini, futhi izobonisa ububanzi bayo. Ngokusebenzisa leli thuluzi, umsebenzisi uqobo uzokwazi ukubona lawo mathuba abona ukuthi ayadingeka. Ngokuya ngokusebenza, ngeke neze ibe ngaphansi kwe-ancelue eyakhelwe ngaphakathi, futhi ngandlela thile ingahle ibe ngaphezulu kunayo. Ukubuyisa okuwukuphela kwento yokuthi uhlu lwethebula ngalinye kufanele ubhale ifomu elihlukile, futhi ungasebenzisi ithempulethi efanayo, ngangokunokwenzeka lapho usebenzisa inguqulo evamile.

1. Njengendlela yangaphambilini, okokuqala, udinga ukwenza inhloko yetafula elizayo ephepheni. Kuzoba namaseli amahlanu anamagama: "Cha.", "Igama lomkhiqizo", "Ubuningi", "Intengo", "Inani".



2. Okulandelayo, sidinga ukwenza okubizwa ngokuthi “itafula” etafuleni lethu, esinamandla okungeza ngokuzenzakalela imigqa lapho ugcwalisa amabanga asondele noma amaseli ngemininingwane. Ukuze wenze lokhu, khetha unhlokweni, futhi, kuthebhu "Ikhaya"chofoza inkinobho "Fometha njengetafula" ebhokisini lamathuluzi Izitayela. Lokhu kuvula uhlu lokukhethwa kukho kwesitayela. Ukuzikhethela komunye wabo ngeke kuthinte ukusebenza nganoma iyiphi indlela, ngakho-ke nje sikhetha inketho esicabanga ukuthi ilungile ngokwengeziwe.



3. Ngemuva kwalokho iwindi elincane lokufometha itafula liyavula. Kubonisa uhla esalwabiwe ngaphambili, okungukuthi, ububanzi bekhanda. Njengomthetho, kule nkambu konke kugcwaliswa kahle. Kepha kufanele sibheke ibhokisi eliseduze kwepharamitha Ithebula Lokuqondisa. Ngemuva kwalokho chofoza inkinobho "Kulungile".



4. Ngakho-ke, ububanzi bethu buhlelwe njengetafula "ehlakaniphile", kufakazelwa ushintsho ekubonisweni okubukwayo. Njengoba ukwazi ukubona, phakathi kwezinye izinto, izithonjana zokuhlunga zivele eceleni kwegama ngalinye lekholomu. Kufanele zikhutshazwe. Ukuze wenze lokhu, khetha noma isiphi iseli lethebula le- "smart" bese uya kuthebhu "Idatha". Kukhona iribhoni kubhokisi lamathuluzi Hlunga nesihlungi chofoza isithonjana "Hlunga".

   

   Kukhona enye inketho yokukhubaza isihlungi. Kulokhu, ngeke futhi kungadingeki ukuthi ushintshele kwenye ithebhu, esele kuthebhu "Ikhaya". Ngemuva kokukhetha amaseli endawo yetafula ku-iribhoni kubhulokhi yezilungiselelo "Ukuhlela" chofoza isithonjana Hlunga nesihlungi. Kuluhlu olubonakala, khetha isikhundla "Hlunga".



5. Njengoba ukwazi ukubona, ngemuva kwalesi senzo, imifanekiso yokuhlunga yanyamalala kunhlokweni yetafula, njengoba kudingeka.



6. Ngemuva kwalokho kufanele sizenzele ifomu lokungenela idatha uqobo. Futhi kuzoba uhlobo lokuhlotshaniswa kwetafula okuqukethe amakholomu amabili. Amagama womugqa wale nto azohambisana namagama ekholamu etafuleni eliphambili. Okuhlukile kungamakholomu "Cha." futhi "Inani". Bayobe bengekho. Eyokuqala izobalwa kusetshenziswa i-macro, futhi inani lesibili lizobalwa ngokufaka ifomula yokuphinda ubungako ngentengo.

   Ikholomu yesibili yento yokungena yedatha ishiywe ingenalutho okwamanje. Ngokuqondile ngokuhamba kwesikhathi amanani azofakwa kuwo ukugcwalisa imigqa yobubanzi bethebula eliphambili.



7. Ngemuva kwaloko sakha itafula linye lelincane. Kuzoba nokholamu owodwa futhi kuzoqukatha uhlu lwemikhiqizo esizoyibonisa kukholamu yesibili yetafula enkulu. Ukucaciswa, iseli elinesihloko salolu hlu ("Uhlu Lomkhiqizo") angagcwaliswa ngombala.



8. Bese ukhetha iseli lokuqala elingenalutho lezinto zokufaka inani. Iya kuthebhu "Idatha". Chofoza isithonjana Ukuqinisekiswa Kwedathaebekwe kubambo kubhokisi lamathuluzi "Sebenza nedatha".



9. Iwindi lokufakazelwa kokufaka liyaqala. Chofoza endle "Uhlobo lwedatha"okuzenzakalelayo ku "Noma iliphi inani".



10. Ukusuka kwezinketho ezivuliwe, khetha isikhundla Uhlu.



11. Njengoba ukwazi ukubona, ngemuva kwalokho, iwindi lokuhlola amanani wokufaka lishintshe kancane ukumiswa kwalo. Kuvele inkambu eyengeziwe "Umthombo". Sichofoza isithonjana ngakwesokunene sayo ngenkinobho yegundane kwesobunxele.



12. Ngemuva kwalokho iwindi lokuhlola okufakwayo liyancishiswa. Khetha uhlu lwedatha ebekwe eshidini endaweni yetafula eyengeziwe nesikhombisi ngenkathi uphethe inkinobho yegundane kwesobunxele "Uhlu Lomkhiqizo". Ngemuva kwalokho, phinda uchofoze kwisithonjana ngakwesokudla sensimu lapho kukhulunywa khona ikheli lebanga elikhethiwe.



13. Lokhu kubuyela ebhokisini lokuhlola lokufaka amanani. Njengoba ukwazi ukubona, izixhumanisi zobubanzi obukhethiwe kuzo sezivele zikhonjisiwe endle "Umthombo". Chofoza inkinobho "Kulungile" phansi kwewindi.



14. Manje, ngakwesokudla seseli elikhethiwe lezinto zokufaka idatha, kuvele isithonjana esinxantathu. Uma ulichofoza, kuvulwa uhlu olwehlayo, olunamagama akhishwe kuhlu lwethebula "Uhlu Lomkhiqizo". Manje akunakwenzeka ukufaka idatha yokuphikisana esitokisini esikhonjisiwe, kepha ungakhetha kuphela isikhundla osifunayo ohlwini olwethuliwe. Khetha into ohlwini olwehliswayo.



15. Njengoba ubona, isikhundla esikhethiwe sakhonjiswa ngaso leso sikhathi enkundleni "Igama lomkhiqizo".



16. Okulandelayo, sizodinga ukunikeza amagama kulawo maseli amathathu amafomu wokufaka lapho sizofaka khona idatha. Khetha iseli lokuqala, lapho igama selivele likhona kithi "Izambane". Okulandelayo, iya kwinkambu yegama lebanga. Itholakala ohlangothini lwesobunxele lwewindi le-Excel ezingeni elifanayo ne-bar formula. Faka igama lokuphikisana lapho. Kungaba yiliphi igama ngesiLatin, lapho kungekho zikhala, kodwa kungcono ukusebenzisa amagama asondele kwimisebenzi exazululwa yilesi sakhi. Ngakho-ke, kubizwa iseli lokuqala, eliqukethe igama lomkhiqizo "Igama". Sibhala leli gama ensimini bese sicindezela ukhiye Ngena kwikhibhodi.



17. Ngendlela efanayo sibeka igama esitokisini esizongena kulo inani lezimpahla "Volum".



18. Neseli ngentengo - "Intengo".



19. Ngemuva kwalokho, ngendlela efanayo esinikeza ngayo igama kulo lonke uhla lwamaseli amathathu angenhla. Okokuqala, khetha, bese uyinika igama emkhakheni okhethekile. Kukhale igama "I-Diapason".



20. Ngemuva kwesenzo sokugcina, kufanele sigcine idokhumenti ukuze amagama esiwabele abonwe yi-macro esiyenzile ngokuzayo. Ukuze ulondoloze, iya kuthebhu Ifayela bese uqhafaza entweni "Gcina Njengo ...".



21. Ewindini elisindayo elivulayo, enkambu Uhlobo lwefayela inani lokukhetha "Incwadi Esekelwayo ye-Excel Macro (.xlsm)". Okulandelayo, chofoza inkinobho Gcina.



22. Ngemuva kwalokho kufanele usebenze ama-macros kuhlobo lwakho lwe-Excel bese unika amandla ithebhu "Unjiniyela"uma ungakenzi. Iqiniso ngukuthi yomibili le misebenzi ikhutshazwe ngokuzenzakalela kuhlelo, futhi ukusebenza kwawo kumele kwenziwe ngamandla ewindini lezilungiselelo ze-Excel.
23. Ngemuva kokuthi ukwenze lokhu, iya kuthebhu "Unjiniyela". Chofoza isithonjana esikhulu "Okubonakalayo okuyisisekelo"etholakala kubambo kubhokisi lamathuluzi "Ikhodi".



24. Isenzo sokugcina sibangela ukuba ukuqala kwesihleli se-VBA macro ukuqala. Endaweni "Iphrojekthi", etholakala engxenyeni engaphezulu kwesokunxele yewindi, khetha igama leshidi lapho amatafula ethu etholakala khona. Kulokhu, kunjalo "Ishidi 1".



25. Ngemuva kwalokho, iya endaweni engezansi kwesobunxele yewindi elibizelwayo "Izindawo". Nazi izilungiselelo zeshidi elikhethiwe. Ensimini "(Igama)" Igama leCyrillic kufanele lishintshwe ("Ishidi1") egameni elibhalwe ngesiLatini. Unganikeza noma yiliphi igama elilungele wena, into esemqoka ukuthi liqukethe izinhlamvu noma izinombolo zesiLatin kuphela futhi azikho ezinye izimpawu noma izikhala. Kungaleli gama ukuthi le macro izosebenza. Masibe kuleli gama "Producty", yize ungakhetha okunye okuhlangabezana nemibandela echazwe ngenhla.

    Ensimini "Igama" Ungase futhi ufake igama ngegama elilula kakhudlwana. Kepha lokhu akudingekile. Kulokhu, ukusetshenziswa kwezikhala, i-Cyrillic kanye nezinye izinhlamvu kuvunyelwe. Ngokungafani nepharamitha yangaphambilini, esetha igama leshidi lohlelo, le pharamitha inikeze igama eshidini elibonakala umsebenzisi kubha yesinqamuleli.

    Njengoba ukwazi ukubona, emva kwalokho igama lizoshintsha ngokuzenzakalelayo Ishidi 1 enkundleni "Iphrojekthi", kwesisanda kumisa kukho kuzilungiselelo.



26. Bese uye enkabeni yewindi. Yilapho sizodinga khona ukubhala ikhodi enkulu kakhulu uqobo. Uma inkambu yesihleli sekhodi emhlophe endaweni ekhonjisiwe ingakhonjisiwe, njengakithi, bese ucindezela inkinobho yokusebenzela F7 futhi kuzovela.



27. Manje ngokwesibonelo sethu esithile, kudingeka sibhale le khodi elandelayo enkundleni:

    
I-Sub DataEntryForm ()
Fiphisha umugqa olandelayo uma ubude
NextRow = Producty.Amaseli (Producty.Rows.Count, 2) .End (xlUp) .Kuphunyisiwe (1, 0) .Row
Ngomkhiqizo
Uma .Range ("A2"). Inani = "" Futhi .Range ("B2"). Inani = "" Bese
olandelayoRow = olandelayoRow - 1
Qeda uma
I-Producty.Range ("Igama"). Kopisha
.Amameli (NextRow, 2) .PasteSpecial Paste: = xlPasteValues
.Amaseli (NextRow, 3) .Value = Producty.Range ("Volum"). Value
.Amaseli (NextRow, 4) .Value = Producty.Range ("Intengo"). Inani
.Amaseli (NextRow, 5) .Value = Producty.Range ("Volum"). Value * Producty.Range ("Intengo"). Inani
.Range ("A2") formula = "= IF (ISBLANK (B2)," "" ", COUNTA ($ B $ 2: B2))"
Uma ngokulandelayoRow> 2 Bese
Ububanzi ("A2") Khetha
Ukukhetha.AutoFill Destination: = Ububanzi ("A2: A" & nextRow)
Ububanzi ("A2: A" & nextRow) .Khetha
Qeda uma
.Range ("Diapason") .I-clearContents
Qeda ngo
Qeda sub

    Kepha le khodi akuyona eyendawo yonke, okungukuthi, ayiguqulwe ifanele icala lethu kuphela. Uma ufuna ukukuvumelanisa nezidingo zakho, khona-ke kufanele kushintshwe ngokufanele. Ukuze ukwazi ukukwenza ngokwakho, ake sibheke ukuthi le khodi iqukethe ini, yini okufanele ifakwe esikhundleni, nokuthi yini okungafanele ishintshwe.

    Ngakho umugqa wokuqala:

    I-Sub DataEntryForm ()

    "IdathaEntryForm" igama le-macro uqobo. Ungayishiya njengoba injalo, noma ungayifaka esikhundleni nganoma yikuphi okunye okuhlangabezana nemithetho ejwayelekile yokwakha amagama wama-macro (azikho izikhala, sebenzisa izinhlamvu zamagama zesiLatin kuphela, njll.). Ukushintsha igama ngeke kuthinte lutho.

    Nomaphi lapho igama livela khona kukhodi "Producty" kufanele ulifakele igama owabeke lona ekuqaleni kweshidi lakho enkundleni "(Igama)" izindawo ze "Izindawo" umhleli we-macro. Ngokwemvelo, lokhu kufanele kwenziwe kuphela uma uyiqambe ishidi ngenye indlela.

    

    Manje cabanga ngalayini:

    NextRow = Producty.Amaseli (Producty.Rows.Count, 2) .End (xlUp) .Kuphunyisiwe (1, 0) .Row

    Digit "2" kulomugqa kusho ikholamu lesibili leshidi. Le kholamu yikholomu "Igama lomkhiqizo". Kuyo sibala inani lemigqa. Ngakho-ke, uma kwimeko yakho ikholomu efanayo ine-oda elihlukile ku-akhawunti, lapho-ke udinga ukufaka inombolo ehambisanayo. Inani "Qeda (xlUp) .Offset (1, 0) .Row" noma kunjalo, shiya singashintshiwe.

    

    Okulandelayo, cabanga ngomugqa

    Uma .Range ("A2"). Inani = "" Futhi .Range ("B2"). Inani = "" Bese

    "A2" - lawa izixhumanisi zeseli lokuqala lapho kuzovezwa khona izinombolo zomugqa. "B2" - lawa izixhumanisi zeseli yokuqala okuzokhipha idatha ngayo ("Igama lomkhiqizo") Uma zingafani, faka idatha yakho esikhundleni salawa maxhumanisi.

    

    Iya kulayini

    Producty.Range ("Igama"). Kopisha

    Inepharamitha "Igama" isho igama esilinikeze insimu "Igama lomkhiqizo" kwifomu lokufaka.

    

    Emigqeni

    
.Amameli (NextRow, 2) .PasteSpecial Paste: = xlPasteValues
.Amaseli (NextRow, 3) .Value = Producty.Range ("Volum"). Value
.Amaseli (NextRow, 4) .Value = Producty.Range ("Intengo"). Inani
.Amaseli (NextRow, 5) .Value = Producty.Range ("Volum"). Value * Producty.Range ("Intengo"). Inani

    amagama "Volum" futhi "Intengo" asho amagama esiwabekele izinkambu "Ubuningi" futhi "Intengo" ngendlela efanayo yokufaka.

    

    Kumigqa efanayo nesikhombisile ngenhla, izinombolo "2", "3", "4", "5" asho izinombolo zekholamu ekhasini lokusebenzela le-Excel elihambisana nezinsika "Igama lomkhiqizo", "Ubuningi", "Intengo" futhi "Inani". Ngakho-ke, uma kwimeko yakho itafula ligudluzwa, kuzodingeka ucele izinombolo zekholomu ezihambisanayo. Uma kunamakholomu amaningi, khona-ke ngokufanekisa udinga ukufaka imigqa yayo kukhodi, uma incane - bese ususa eyengeziwe.

    

    Ulayini uphinda inani lezimpahla ngentengo yalo:

    .Amaseli (NextRow, 5) .Value = Producty.Range ("Volum"). Value * Producty.Range ("Intengo"). Inani

    Umphumela, njengoba sibona kusiqalo serekhodi, sizokhonjiswa kwikholomu yesihlanu kwekhasi lokusebenzela le-Excel.

    

    Le nkulumo yenza izinombolo zomugqa ozenzakalelayo:

    
Uma ngokulandelayoRow> 2 Bese
Ububanzi ("A2") Khetha
Ukukhetha.AutoFill Destination: = Ububanzi ("A2: A" & nextRow)
Ububanzi ("A2: A" & nextRow) .Khetha
Qeda uma

    Onke amanani "A2" kusho ikheli leseli lokuqala lapho kuzokwenziwa khona izinombolo, futhi izixhumanisi "A " - Ikheli layo yonke ikholomu enezinombolo. Bheka ukuthi kuzoboniswa kuphi ngempela ukubala etafuleni lakho bese uguqula lokhu kuhlanganiswa kukhodi, uma kunesidingo.

    

    Ulayini uhlanze ibanga lefomu lokungenela idatha ngemuva kokuthi imininingwane evela kulo idluliselwe etafuleni:

    .Range ("Diapason") .I-clearContents

    Akunzima ukuqagela ukuthi ("I-Diapason") Kusho igama lobubanzi esalinikeze izinkambu zokungenela idatha ngaphambili. Uma ubanikeze igama elihlukile, khona-ke lo mugqa kufanele ufakwe ngqo lokho.

    

    Enye ingxenye yekhodi yendawo yonke futhi kuzo zonke izimo izokwethulwa ngaphandle kwezinguquko.

    Ngemuva kokuthi urekhode ikhodi enkulu kumafayili wokuhlela, chofoza isithonjana sokugcina ngendlela yediski engxenyeni engakwesokunxele yewindi. Ngemuva kwalokho ungayivala ngokuchofoza inkinobho evamile yokuvala amawindi ekhoneni eliphezulu kwesokudla.



28. Ngemuva kwalokho, sibuyela eshidini le-Excel. Manje sidinga ukubeka inkinobho ezokwenza isebenze iMacro edaliwe. Ukuze wenze lokhu, iya kuthebhu "Unjiniyela". Ebhuthini yezilungiselelo "Izilawuli" kubambo, chofoza inkinobho Namathisela. Uhlu lwamathuluzi luyavula. Eqenjini lamathuluzi "Izilawuli Zamafomu" khetha eyokuqala - Inkinobho.



29. Ngemuva kwalokho, ngokucindezela inkinobho yenkinobho yesinxele, dweba ikhesa ngaphezulu kwendawo lapho sifuna ukubeka khona inkinobho yokuqalisa iMacro, ezodlulisa imininingwane kusuka kwifomu iye etafuleni.



30. Ngemuva kokuthi indawo isiyingiwe, khipha inkinobho yegundane. Ngemuva kwalokho, iwindi le-macro labelo lwento liqala ngokuzenzakalelayo. Uma kusetshenziswa ama-macros amaningana encwadini yakho, bese ukhetha igama lalowo esidale ngenhla ohlwini. Siyibiza "IdathaEntryForm". Kepha kulokhu, iMacro yinye, ngakho-ke vele ukhethe bese uchofoza inkinobho "Kulungile" phansi kwewindi.



31. Ngemuva kwalokho, ungaqamba kabusha inkinobho njengoba ufuna, ngokugqamisa igama layo lamanje.

    

    Isibonelo, ngokwesibonelo, kungaba nengqondo ukumnika igama Faka. Qamba kabusha bese uqhafaza kunoma iyiphi iseli yamahhala eshidini.



32. Ngakho-ke, ifomu lethu lilungele ngokuphelele. Ake sibheke ukuthi isebenza kanjani. Faka amanani adingekayo emikhakheni yawo bese uchofoza inkinobho Faka.



33. Njengoba ukwazi ukubona, amanani athuthelwa etafuleni, umugqa unikezwa ngokuzenzakalela inombolo, inani libalwa, amasimu amafomu ayahlanzwa.



34. Gcwalisa lefomu bese uchofoza inkinobho Faka.



35. Njengoba ukwazi ukubona, umugqa wesibili nawo uyangezelelwa kuloluhlu lwethebula. Lokhu kusho ukuthi ithuluzi liyasebenza.

Funda futhi:
Ungayakha kanjani iMacro ku-Excel
Ungayakha kanjani inkinobho ku-Excel

Ku-Excel, kunezindlela ezimbili zokusebenzisa ifomu lokugcwalisa idatha: elakhelwe ngaphakathi nelichazwe umsebenzisi. Sebenzisa inketho eyakhelwe ngaphakathi kudinga ubuncane bomzamo ovela kumsebenzisi Ungahlala uyiqala ngokungeza isithonjana esihambisanayo kubha yamathuluzi yokufinyelela esheshayo. Udinga ukuzakhela ifomu ngokwezifiso, kepha uma uyazi kahle ikhodi ye-VBA, ungenza leli thuluzi liguqulwe futhi lilungele izidingo zakho ngangokunokwenzeka.