Maofesi Olowa Zipangizo za Microsoft Excel

Pofuna kukonza deta mu Excel, mungagwiritse ntchito mawonekedwe apadera omwe angakuthandizenso kufulumira ndondomeko yodzazidwa ndi tebulo. Mu Excel pali chida chogwiritsidwa ntchito chomwe chimalola kuloza ndi njira yomweyo. Wogwiritsa ntchitoyo akhoza kukhalanso ndi mawonekedwe ake a mawonekedwe, omwe adzasinthidwa mozama ku zosowa zake pogwiritsa ntchito macro pa izi. Tiyeni tiwone ntchito zosiyanasiyana za zida zowonjezera zowonjezera mu Excel.

Kugwiritsa ntchito zida zodzaza

Fomu ya kudzazidwa ndi chinthu ndi minda yomwe mayina awo amalembedwa ndi mayina a mndandanda wa ndondomeko ya tebulo yodzaza. M'madera awa muyenera kulowa deta ndipo nthawi yomweyo adzawonjezeredwa ku mzere watsopano m'ndandanda wa tebulo. Fomu ikhoza kugwira ntchito monga chojambulidwa chokhacho ku Excel, kapena kuyika mwachindunji pa pepala mwa mawonekedwe ake, ngati ilo linalengedwa ndi wosuta mwiniwake.

Tsopano tiyeni tiwone momwe tingagwiritsire ntchito zida ziwiri izi.

Njira 1: Chinthu cholowetsamo cha data cha Excel

Choyamba, tiyeni tiphunzire momwe tingagwiritsire ntchito mawonekedwe olowera ma data a Excel.

1. Tiyenera kukumbukira kuti mwachisawawa chithunzi chomwe chimayambitsa icho chabisika ndipo chiyenera kuchitidwa. Kuti muchite izi, pitani ku tabu "Foni"ndiyeno dinani pa chinthu "Zosankha".



2. Muwindo lotseguka lafelelo la Excel ife timasunthira ku gawolo "Bwalo Lofikira Bwino". Zowonjezera zambiri zimakhala ndi malo okonzera malo. Mbali ya kumanzere ndi zipangizo zomwe zingathe kuwonjezeredwa pazowunikira mwamsanga, ndipo moyenera - zomwe zilipo kale.

   Kumunda "Sankhani magulu ochokera" ikani mtengo "Magulu sali pa tepi". Kenako, kuchokera mndandanda wa malamulo omwe ali muzithunzithunzi, timapeza ndikusankha malo "Fomu ...". Kenaka dinani pa batani "Onjezerani".



3. Pambuyo pake, chida chimene tikusowa chidzawonekera kumanja kwawindo. Timakanikiza batani "Chabwino".



4. Tsopano chida ichi chili muwindo la Excel pazomwe mungapezeko, ndipo tikhoza kuchigwiritsa ntchito. Adzakhalapo pamene buku lililonse la ntchito lidzatsegulidwa ndi chitsanzo ichi cha Excel.



5. Tsopano, kuti chida chakumvetsetsa chimene chikufunikira kudzaza, muyenera kukonza mutu wa tebulo ndikulemba mtengo uliwonse. Lolani magome omwe timakhala nawo adzakhala ndi zigawo zinayi, zomwe ziri ndi mayina "Dzina la Zamalonda", "Zambiri", "Mtengo" ndi "Mtengo". Lowetsani mainawa mu pepala lopanda malire.



6. Komanso, kuti pulogalamuyi idziwe mapepala omwe akufunika kugwira nawo ntchito, muyenera kulowa muyeso loyambirira pa tebulo.



7. Pambuyo pake, sankhani selo lirilonse la tebulo losalemba ndipo dinani pazithunzi muzowunikira mwamsanga "Fomu ..."zomwe tachita kale.



8. Kotero, zenera la chida chofotokozedwa chikuyamba. Monga mukuonera, chinthu ichi chiri ndi minda yomwe ikufanana ndi mayina a zigawo za tebulo lathu. Pachifukwa ichi, munda woyamba uli wodzaza ndi phindu, popeza tinalowamo pamanja.



9. Lowetsani zikhulupiliro zomwe timaganiza kuti ndizofunikira m'minda yotsalayo, kenako dinani pa batani "Onjezerani".



10. Pambuyo pake, monga momwe tikuonera, malingaliro omwe adalowawo adasinthidwa mzere woyamba pa tebulo, ndipo mawonekedwewo amapita kumalo ena, omwe akufanana ndi mzere wachiwiri wa tebulo.



11. Lembani zenerazenera ndi zida zomwe tikufuna kuziwona mzere wachiwiri wa tablespace, ndipo dinani batani kachiwiri. "Onjezerani".



12. Monga momwe mukuonera, miyezo ya mzere wachiwiri idawonjezedwanso, ndipo sitinayambe kukonzanso ndondomekoyo patebulo lokha.



13. Choncho, timadzaza tebulo ndi mfundo zonse zomwe tikufuna kulowa mmenemo.



14. Kuonjezerapo, ngati mukufuna, mutha kuyenda kudzera muzomwe mumalowetsamo pogwiritsa ntchito mabatani "Kubwerera" ndi "Kenako" kapena scrollbar yowongoka.



15. Ngati ndi kotheka, mukhoza kusintha kusintha kulikonse patebulo pothandizira mu mawonekedwe. Kuti kusintha kuoneke pa pepala, mutatha kuwayika muzitsulo zoyenera, dinani pa batani "Onjezerani".



16. Monga mukuonera, kusintha kumeneku kunachitika mwamsanga pa tablespace.



17. Ngati tifunika kuchotsa mzere, ndiye kudzera muzitsulo zoyendetsa kapena mpukutu wamatabwa, timapitiliza kumalo ozungulira mu mawonekedwe. Pambuyo pake dinani pa batani "Chotsani" muwindo lazitali.



18. Bokosi lakulangizitsa likuwoneka, likusonyeza kuti mzere udzachotsedwa. Ngati mukukhulupirira zochita zanu, ndiye dinani pa batani "Chabwino".



19. Monga momwe mukuonera, mzere unachotsedwa pa tebulo la tebulo. Pambuyo pomaliza ndi kukonzanso, mutha kuchoka pazenera pazenera powonjezera. "Yandikirani".



20. Pambuyo pake, kuti mupangitse tebulo kupanga zithunzi zambiri, mukhoza kuziyika.

Njira 2: Pangani mawonekedwe apangidwe

Kuwonjezera apo, pogwiritsa ntchito zida zambiri ndi zida zina, ndizotheka kupanga fomu yanuyi kuti mudzaze tebulo. Icho chidzapangidwira mwachindunji pa pepala, ndipo chiyimira mtundu wake. Ndi chida ichi, wogwiritsa ntchito mwiniwakeyo akhoza kuzindikira zinthu zomwe amaona kuti ndizofunikira. Pogwiritsa ntchito, sizingakhale zocheperapo ndi chifaniziro chofanana cha Excel, ndipo mwa njira zina, mwina, kupitirira. Chokhachokha chokha ndi chakuti pa gulu lililonse, muyenera kupanga mawonekedwe osiyana, osagwiritsa ntchito template yomwe ingatheke pogwiritsira ntchito ndondomeko yoyenera.

1. Monga mwa njira yapitayi, choyamba, muyenera kupanga mutu wa tebulo mtsogolo pa pepala. Lidzakhala ndi maselo asanu omwe ali ndi mayina: "P / p nambala", "Dzina la Zamalonda", "Zambiri", "Mtengo", "Mtengo".



2. Kenaka muyenera kupanga tebulo lotchedwa "wochenjera" kuchokera patebulo lathu, ndikutha kuwonjezera mizera pamene mukudzaza mitsinje yoyandikana kapena maselo okhala ndi deta. Kuti muchite izi, sankhani mutu komanso, pokhala pa tabu "Kunyumba"pressani batani "Pangani monga tebulo" mu chigawo cha zipangizo "Masitala". Pambuyo pake mndandanda wamasewero omwe alipo alipo. Kusankha kwa mmodzi wa iwo sikungakhudze ntchitoyo mwa njira iliyonse, kotero timangosankha chisankho chomwe timaganizira moyenera.



3. Kenaka mawindo otsegulira tebulo amatsegula. Zimasonyeza zosiyana zomwe tidaziwonetsa, ndiko kuti, kapu ya kapu. Monga lamulo, gawo ili ladzaza molondola. Koma tiyenera kuyang'ana bokosi pafupi "Mndandanda ndi mutu". Pambuyo pake, dinani pa batani "Chabwino".



4. Kotero, maonekedwe athu amawonekedwe ngati tebulo lapamwamba, ngakhale zikuwonetsedwa ndi kusintha kwa zithunzi. Monga mukuonera, pakati pazinthu zina, kufotokoza zithunzi kumapezeka pafupi ndi mutu uliwonse. Ayenera kukhala olumala. Kuti muchite izi, sankhani selo lirilonse mu tebulo lapamwamba ndikupita ku tabu "Deta". Kumeneko pa tepiyi mu chida cha zipangizo "Sankhani ndi kusefera" dinani pazithunzi "Fyuluta".

   

   Palinso njira ina yosokonezera fyuluta. Simusowa ngakhale kusinthana ku tabu ina, mukakhalabe pa tabu "Kunyumba". Mukasankha selo la tablespace pa riboni m'makonzedwe Kusintha dinani pazithunzi "Sankhani ndi kusefera". M'ndandanda imene ikuwonekera, sankhani malo "Fyuluta".



5. Monga mukuonera, patatha izi, mafano osungunula adafalikira kuchokera ku gome, monga pakufunira.



6. Ndiye tiyenera kupanga fomu yolowera deta yokha. Zidzakhalanso mtundu wa malemba omwe ali ndi zipilala ziwiri. Mayina a mzere wa chinthu ichi adzalumikizana ndi mayina a pamndandanda wa tebulo lalikulu. Kupatulapo ndi zipilala "P / p nambala" ndi "Mtengo". Iwo sadzakhalapo. Chiwerengero cha choyamba chidzachitika pogwiritsa ntchito macro, ndipo chiwerengero cha zikhulupiliro zachiwiri chidzachitike mwa kugwiritsa ntchito njira yowonjezera kuchuluka kwa mtengo.

   Chigawo chachiwiri cha chinthu cholowetsa deta chatsalalika pakali pano. Mwachindunji, ziyeneretso zodzaza mzere wa mndandanda waukulu wa tebulo zidzalowa mmbuyo mtsogolo.



7. Pambuyo pake timapanga tebulo lina laling'ono. Idzakhala ndi ndondomeko imodzi ndipo idzakhala ndi mndandanda wa zinthu zomwe tidzasonyeze mu gawo lachiwiri la tebulo lalikulu. Kuti ziwoneke, selo liri ndi mutu wa mndandanda uwu ("Mndandanda wa katundu") mukhoza kudzaza ndi mtundu.



8. Kenaka sankhani selo yoyamba yopanda kanthu ya chinthu chopindulitsa chofunika. Pitani ku tabu "Deta". Dinani pazithunzi "Verification Data"yomwe imayikidwa pa tepi mu zida za zipangizo "Kugwira ntchito ndi deta".



9. Fayilo yowonjezera yowonjezera ikuyamba. Dinani kumunda Mtundu wa Deta "momwe kukhazikitsa kosasintha kuli "Mtengo uliwonse".



10. Kuchokera pazomwe mungasankhe, sankhani malo "Lembani".



11. Monga mukuonera, patapita izi, zowonjezera zowunika zowonjezera zamasintha zinasintha machitidwe ake. Pali malo ena "Gwero". Timakani pa chithunzi kumanja kwake ndi batani lamanzere.



12. Ndiye zenera zowunika zowonjezera zimachepetsedwa. Sankhani ndondomeko ndi batani lamanzere lomwe liri ndi mndandanda wa deta yomwe yaikidwa pa pepala m'deralo. "Mndandanda wa katundu". Pambuyo pake, dinani kachidindo pazithunzi kumanja kwa munda umene aderesi ya osankhidwayo adawonekera.



13. Ikubwerera ku bokosi la zowonjezera. Monga mukuonera, makonzedwe a osankhidwa omwe ali mmenemo ali kale m'munda "Gwero". Dinani pa batani "Chabwino" pansi pazenera.



14. Tsopano chithunzi mwa mawonekedwe a katatu chinkawonekera kumanja kwa selo lopanda kanthu la chinthu cholowetsa deta. Mukamatula pazomwe, mndandanda wotsika pansi ukuyamba, wopangidwa ndi mayina omwe amachokera pa tebulo. "Mndandanda wa katundu". Deta yosasinthika mu selo yeniyeniyo tsopano ndi yosatheka kulowa, koma mutha kusankha yekha malo omwe mukufuna kuchokera mndandanda womwe waperekedwa. Sankhani chinthu mundandanda wotsika pansi.



15. Monga mukuonera, malo osankhidwa amasonyezedwa pomwepo m'munda "Dzina la Zamalonda".



16. Pambuyo pake, tidzafunika kugawa maina ku maselo atatu a mawonekedwe olembera, kumene tilowetsa deta. Sankhani selo yoyamba kumene dzina lanu latha kale. "Mbatata". Kenaka, pitani ku mndandanda wa mayina. Ili pambali ya kumanzere kwawindo la Excel pamlingo womwewo monga bar. Lowani mmenemo dzina lopanda dzina. Izi zikhoza kukhala dzina lirilonse m'Chilatini, momwe mulibe malo, koma ndi bwino kugwiritsa ntchito mayina pafupi ndi ntchito yothetsedwe ndi izi. Choncho, selo yoyamba yomwe dzina la mankhwalawa ili ndiyitanidwa "Dzina". Timalemba dzina ili m'munda ndikusindikiza fungulo Lowani pabokosi.



17. Momwemonso, perekani selo limene ife timalowa mu kuchuluka kwa mankhwala, dzina "Volum".



18. Ndipo selo ya mtengo ndi "Mtengo".



19. Pambuyo pake, mwa njira yomweyo, timapatsa dzina lonse la maselo atatu pamwambapa. Choyamba, sankhani, ndikumupatsanso dzina lapadera. Lembani dzinali "Zosasangalatsa".



20. Pambuyo pachitsiriza chotsiriza, tifunika kusunga chikalata kuti maina omwe timapereka angazindikire zomwe timapanga m'tsogolomu. Kuti mupulumutse, pita ku tab "Foni" ndipo dinani pa chinthu "Sungani Monga ...".



21. Muwindo lotsegula lotseguka m'munda "Fayilo Fayilo" sankhani mtengo "Macro-Enabled Excel Workbookbook (.xlsm)". Kenako, dinani pakani Sungani ".



22. Ndiye mumayenera kuika macros mu Excel yanu ndikuthandizani tab "Wotsambitsa"ngati simunachitepobe. Chowonadi ndi chakuti ntchito zonsezi zimalephereka mwachisawawa pulogalamuyi, ndipo kuyambitsa kwawo kuyenera kuchitidwa mwachangu muzenera zowonetsera Excel.
23. Mukachita izi, pitani ku tabu "Wotsambitsa". Dinani pa chithunzi chachikulu "Visual Basic"yomwe ili pa tepiyi mu zida za zipangizo "Code".



24. Chotsatira chotsiriza chimayambitsa VR macro editor kuti ayambe. Kumaloko "Project"yomwe ili kumtunda kumanzere kwawindo, sankhani dzina la pepala limene matebulo athu ali. Pankhaniyi ndi "Mzere 1".



25. Pambuyo pake pita kumunsi kumanzere kwawindo lotchedwa "Zolemba". Pano pali makonzedwe a pepala losankhidwa. Kumunda "(Dzina)" ayenera kutengera dzina lachi Cyrilli ("Sheet1") pa dzina lolembedwa mu Chilatini. Dzina likhoza kuperekedwa kwa aliyense yemwe ali losavuta kwa inu, chinthu chachikulu ndi chakuti liri ndi zilembo za Chilatini kapena manambala ndipo palibe zizindikiro kapena malo ena. Zambiri zidzagwira ntchito ndi dzina ili. Lolani ifeyo dzina ili lidzakhala "Producty", ngakhale mutha kusankha zina zomwe zikugwirizana ndi zomwe tatchula pamwambapa.

    Kumunda "Dzina" Mungathenso kutchulidwanso dzina ndi losavuta kwambiri. Koma sikofunikira. Pankhaniyi, kugwiritsa ntchito malo, Cyrillic ndi zizindikiro zina zimaloledwa. Mosiyana ndi gawo lapitalo, lomwe limatchula dzina la pepala la pulojekitiyi, izi zimapatsa dzina ku pepala lomwe likuwoneka kwa wosuta mu barre ya njira.

    Monga mukuonera, pambuyo pake dzina lidzasintha. Mapepala 1 m'deralo "Project", kwa omwe tangokhala kumene.



26. Kenaka pitani kuchigawo chapakati pawindo. Apa ndi pamene tifunika kulemba code yaikulu. Ngati malo omasewera a code code mu malo omwe asankhidwa sakuwonetsedwa, monga momwe timachitira, ndiye dinani pafungulo la ntchito. F7 ndipo izo zidzawonekera.



27. Tsopano chifukwa cha chitsanzo chathu, tikuyenera kulemba malemba awa mmunda:

    
Sub DataEntryForm ()
Dzukani lotsatiraKuda Kwambiri
chotsatiraRow = Producty.Cells (Producty.Rows.Count, 2) .End (xlUp) .Ndalama (1, 0)
Ndi Producty
Ngati .Range ("A2") Phindu = "" Ndipo .Range ("B2").
Yotsatira = Yotsatira - 1
Kutha ngati
Producty.Range ("Dzina")
.Selo (lotsatiraRowani, 2) .PasteSpecial Paste: = xlPasteValues
Maselo (lotsatiraRowani, 3) .Value = Producty.Range ("Volum")
Maselo (lotsatiraRowani, 4) .Value = Producty.Range ("Mtengo")
Zowonjezera (lotsatira, 5) .Value = Producty.Range ("Volum"). Mtengo * Producty.Range ("Mtengo").
Pangani ("A2") Fomu = "= IF (ISBLANK (B2)," "", COUNTA ($ B $ 2: B2)) "
NgatizotsatiraZotsatira> 2 Ndiye
Mtundu ("A2"). Sankhani
Kusankha.Kusintha kwa malo: = Chigawo ("A2: A" & nextRow)
Mtundu ("A2: A" & nextRow) .Select
Kutha ngati
.Range ("Zosavuta")
Kutsiriza ndi
Malizani pang'ono

    Koma chiwerengerochi sichiri chilengedwe chonse, ndiko kuti, chimangokhala chokwanira pazochitika zathu. Ngati mukufuna kusintha malingana ndi zosowa zanu, ndiye kuti ziyenera kusinthidwa molingana. Kuti mutha kuzichita nokha, tiyeni tione m'mene chiwerengerochi chiliri, chomwe chiyenera kusinthidwa, ndi zomwe siziyenera kusinthidwa.

    Choncho, mzere woyamba:

    Sub DataEntryForm ()

    "DataEntryForm" ndi dzina la macro palokha. Mukhoza kuchoka monga momwe zilili, kapena mungathe kuzilemba ndi zina zomwe zikugwirizana ndi malamulo omwe amapanga mayina akulu (palibe malo, gwiritsani ntchito malemba a zilembo za Chilatini, ndi zina zotero). Kusintha dzina sikukhudza chirichonse.

    Kulikonse kumene mawu amapezeka mu code "Producty" muyenera kuzitsatira m'malo ndi dzina lomwe munapatsa pepala lanu m'munda "(Dzina)" madera "Zolemba" mkonzi wamkulu. Mwachibadwa, izi ziyenera kuchitika kokha ngati mwaitanira pepala mosiyana.

    

    Tsopano ganizirani mzere wotsatira:

    chotsatiraRow = Producty.Cells (Producty.Rows.Count, 2) .End (xlUp) .Ndalama (1, 0)

    Digit "2" mu mzerewu kumatanthauza gawo lachiwiri la pepala. Ndilo mu ndime iyi yomwe gawoli liri "Dzina la Zamalonda". Malinga ndi izo tidzakhala ndi chiwerengero cha mizere. Choncho, ngati inu muli ndi gawo lomwelo ndi dongosolo losiyana la akauntiyi, ndiye kuti muyenela kulemba nambala yofananayo. Meaning "Kutha (xlUp) .Ndalama (1, 0) .Row" mulimonsemo, musiyeni osasintha.

    

    Kenako, ganizirani mzere

    Ngati .Range ("A2") Phindu = "" Ndipo .Range ("B2").

    "A2" - Awa ndiwo makonzedwe a selo yoyamba yomwe mzere wowerengera udzawonetsedwa. "B2" - awa ndiwo makonzedwe a selo yoyamba, yomwe idzagwiritsidwe ntchito pa deta yotulutsa ("Dzina la Zamalonda"). Ngati iwo ali osiyana, lowetsani deta yanu mmalo mwa makonzedwe awa.

    

    Pitani ku mzere

    Producty.Range ("Dzina")

    M'malo mwake "Dzina" tanthawuzani dzina lomwe tapatsidwa kumunda "Dzina la Zamalonda" mu mawonekedwe olowera.

    

    Mu mizere

    
.Selo (lotsatiraRowani, 2) .PasteSpecial Paste: = xlPasteValues
Maselo (lotsatiraRowani, 3) .Value = Producty.Range ("Volum")
Maselo (lotsatiraRowani, 4) .Value = Producty.Range ("Mtengo")
Zowonjezera (lotsatira, 5) .Value = Producty.Range ("Volum"). Mtengo * Producty.Range ("Mtengo").

    mayina "Volum" ndi "Mtengo" tanthawuzani maina omwe tapatsidwa kuminda "Zambiri" ndi "Mtengo" mu mawonekedwe omwewo opatsirana.

    

    Mzere womwewo umene tanena pamwambapa, nambala "2", "3", "4", "5" tanthawuzani manambala a pamzere pa pepala la Excel lofanana ndi zipilala "Dzina la Zamalonda", "Zambiri", "Mtengo" ndi "Mtengo". Choncho, ngati mwawona tebulo likusinthidwa, ndiye kuti muyenera kufotokoza zofanana ndi ziwerengero zam'mbali. Ngati pali zowonjezereka, ndiye kuti mukuyerekezera kuti muwonjezere mizere yake, ngati ndizochepa, chotsani zina.

    

    Mzere umachulukitsa kuchuluka kwa katundu ndi mtengo wawo:

    Zowonjezera (lotsatira, 5) .Value = Producty.Range ("Volum"). Mtengo * Producty.Range ("Mtengo").

    Chotsatira, monga momwe tikuwonera m'mawu ovomerezeka a mbiri, zidzawonetsedwa muzamu lachisanu la pepala la Excel.

    

    Mmawu awa, mizere imangowonjezera:

    
NgatizotsatiraZotsatira> 2 Ndiye
Mtundu ("A2"). Sankhani
Kusankha.Kusintha kwa malo: = Chigawo ("A2: A" & nextRow)
Mtundu ("A2: A" & nextRow) .Select
Kutha ngati

    Zotsatira zonse "A2" tanthawuzani adiresi ya selo yoyamba yomwe chiwerengero chidzachitidwa, ndi makonzedwe "A " - adiresi ya mzere wonse ndi chiwerengero. Onetsetsani kuti chiwerengerochi chidzawoneka bwanji m'tawuni yanu ndikusintha makontheti mu code, ngati kuli kofunikira.

    

    Mzere umachepetsa mawonekedwe a fomu yolowera deta pambuyo pomwe chidziwitso chochokera mmenemo chapitsidwira patebulo:

    .Range ("Zosavuta")

    Sikovuta kuganiza kuti ("Zosasangalatsa") amatanthauza dzina lazomwe tinapereka kale m'minda kuti tipeze ma data. Ngati munawapatsa dzina losiyana, ndiye kuti liyenera kuikidwa mu mzerewu.

    

    Zotsatira zonsezi ndizomwe zimapangidwa popanda kusintha.

    Mutatha kulemba makalata aakulu muwindo la editor, muyenera kudumpha pasungidwe ngati chizindikiro cha diskette kumbali ya kumanzere pawindo. Kenaka mukhoza kutsekera pakhomopo pazenera kuti mutseke mawindo kumtunda wakumanja.



28. Pambuyo pake, bwererani ku pepala la Excel. Tsopano tifunika kuyika batani yomwe idzayambitsa zolengedwa zambiri. Kuti muchite izi, pitani ku tabu "Wotsambitsa". Mu bokosi lokhalamo "Controls" pa tepicho dinani batani Sakanizani. Mndandanda wa zida zimatsegulidwa. Mu gulu la zida Mawonekedwe a Fomu sankhani woyamba - "Bulu".



29. Kenaka ndi batani lamanzere lomwe limagwiritsidwa ntchito, timapukuta kuzungulira dera limene tikufuna kuyika bokosi lalikulu loyambitsa, lomwe lidzasuntha deta kuchokera pa fomu kupita ku gome.



30. Pambuyo pozungulira deralo, kumasula batani. Kenaka zenera popereka chinthu choyamba kumayambira. Ngati ma macros angapo amagwiritsidwa ntchito m'buku lanu, sankhani kuchokera pa mndandanda dzina la amene tinapanga pamwambapa. Ife timachitcha izo "DataEntryForm". Koma pakadali pano, lalikulu ndi imodzi, kotero ingosankha ilo ndipo dinani pa batani "Chabwino" pansi pazenera.



31. Pambuyo pake, mukhoza kutcha dzina la batani monga mukulifunira, pokhapokha mutasankha dzina lake lenileni.

    

    Mwa ife, mwachitsanzo, zingakhale zomveka kumupatsa dzina "Onjezerani". Bwerezaninso ndi dinani ndi mbewa pa selo iliyonse yaulere ya pepala.



32. Kotero, mawonekedwe athu ndi okonzeka kwathunthu. Onani momwe zimagwirira ntchito. Lowani mfundo zoyenera m'minda yake ndipo dinani pa batani. "Onjezerani".



33. Monga momwe mukuonera, miyezo imasunthira ku gome, mzerewu umapatsidwa nambala, chiwerengerocho chiwerengedwa, mawonekedwe a mawonekedwe achotsedwa.



34. Bweretsani mawonekedwewo ndipo dinani pa batani. "Onjezerani".



35. Monga mukuonera, mzere wachiwiri umaphatikizidwanso pa tebulo. Izi zikutanthauza kuti chida chikugwira ntchito.

Onaninso:
Momwe mungapangire macro ku Excel
Momwe mungapangire batani mu Excel

Mu Excel, pali njira ziwiri zomwe mungagwiritsire ntchito fomu yodzaza deta: yomangidwa ndi wogwiritsa ntchito. Kugwiritsiridwa kwa machitidwe omangidwako kumafuna kuchepetsa khama kuchokera kwa wogwiritsa ntchito. Ikhoza nthawi zonse kuyamba ndi kuwonjezera chithunzi chofanana ndi galasi lofikira. Muyenera kupanga mawonekedwe anu enieni, koma ngati muli ndi VBA yabwino, mukhoza kugwiritsa ntchito chida ichi kuti chikhale chosangalatsa komanso choyenera pa zosowa zanu.