Mukati
Kazhinji, vashandisi vemupepeti wespredishiti vanotarisana nebasa rakadaro sekugadzira fomu yakakosha yekupinda ruzivo rwakakosha. Mafomu ifomu rinobatsira kufambisa nzira yekuzadza gwaro respredishiti. Mupepeti ane chishandiso chakabatanidzwa chinokutendera kuti uzadze pepa rebasa nenzira iyi. Mukuwedzera, mushandisi wepurogiramu, achishandisa macro, anogona kugadzira shanduro yake yefomu, yakagadziridzwa kumabasa akasiyana-siyana. Muchinyorwa chacho, tichaongorora zvakadzama nzira dzakasiyana-siyana dzinokubvumira kuti ugadzire fomu mugwaro respredishiti.
Kushandisa maturusi ekuzadza mupepeti yespredishiti
Fomu rekuzadza chinhu chakakosha chine minda ine mazita anoenderana nemazita emakoramu endiro iri kuzadzwa. Izvo zvinodiwa kutyaira mune ruzivo muminda, iyo ichakurumidza kuiswa semutsara mutsva munzvimbo yakasarudzwa. Ichi chimiro chakakosha chinogona kushandiswa sechinhu chakamira-chega chakabatanidzwa chespredishiti kana chinogona kuwanikwa pabepa rebasa pacharo senge. Ngationgororei musiyano wega wega mune zvakadzama.
Nzira yekutanga: chinhu chakabatanidzwa chekuisa ruzivo
Ngatitangei kufunga kuti tingashandisa sei fomu rakasanganiswa kuwedzera ruzivo kugwaro remupepeti wespredishiti. Detailed mirairo inoita seizvi:
- Ziva kuti pakutanga, iyo icon inosanganisira iyi fomu yakavanzwa. Isu tinofanirwa kuita activation process yechishandiso. Isu tinotamira kune "Faira" submenu, iri kumusoro kuruboshwe chikamu chespredishiti edhita interface. Isu tinowana pano chinhu chine zita rekuti "Parameters", uye tinya pairi nebhatani rekuruboshwe.
- Hwindo rakanzi "Excel Options" rakaonekwa pachiratidziro. Isu tinotamira kune chikamu che "Quick Access Panel". Pane zvakawanda zvakasiyana-siyana zvekugadzirisa pano. Kurutivi rworuboshwe kune maturusi anokosha anogona kushandiswa mubhokisi rekushandisa, uye kudivi rekurudyi kwatove kusanganisirwa maturusi. Wedzera rondedzero padivi pechinyorwa "Sarudza mirairo kubva:" uye sarudza chinhu "Mirairo paribhoni" neruboshwe mbeva bhatani. Mune rondedzero yemirairo inoratidzwa mukurongeka kwearufabheti, tiri kutsvaga chinhu "Fomu ..." uye wochisarudza. Dzvanya "Wedzera".
- Tinya bhatani "OK".
- Taita kuti chishandiso ichi chishande paribhoni yakakosha.
- Iye zvino tinoda kutanga kugadzira musoro weplate, uye wozoisa mamwe zviratidzo mairi. Tafura yedu ichave ine makoramu mana. Tinotyaira mumazita.
- Isu tinotyairawo mune imwe kukosha mumutsara wekutanga wendiro yedu.
- Isu tinosarudza chero munda wendiro yakagadzirirwa uye tinya pane "Fomu ..." chinhu chiri paribhoni rekushandisa.
- Iwindo rezvigadziriso zvezvishandiso rinovhura. Heino mitsetse inoenderana nemazita emakoramu endiro.
Zvakakosha kucherechedza kuti mutsara wekutanga wakatozadzwa nedata, sezvo isu takambovaisa pane pepa rekushanda isu pachedu.
- Isu tinotyaira muzviratidzo zvatinoona zvakakodzera mumitsetse yasara. Dzvanya bhatani rekuti "Wedzerai".
- Zviratidzo zvakapinda zvakangoendeswa kune mutsara wekutanga wetafura, uye mufomu pachayo, shanduko yakaitwa kune imwe bhuroka yeminda inoenderana ne1nd mutsara wetafura.
- Tinozadza hwindo rekushandisa nezviratidzo zvatinoda kuona mumutsara wechipiri weplate. Tinya "Add".
- Zviratidzo zvakapinda zvakangoendeswa kune 2nd line yeplate, uye mufomu pachayo, shanduko yakaitwa kune imwe bhuroti yeminda inoenderana ne3rd line yeplate.
- Nenzira yakafanana, tinozadza ndiro nezviratidzo zvose zvinodiwa.
- Uchishandisa "Inotevera" uye "Kumashure" mabhatani, unogona kufamba kuburikidza neakambopinda zviratidzo. Imwe nzira ndeye scroll bar.
- Kana uchida, unogona kugadzirisa chero zviratidzo mutafura nekuzvigadzirisa mufomu pachayo. Kuti uchengetedze shanduko dzako, tinya pakanzi "Wedzera".
- Isu tinoona kuti ese akagadziridzwa maitiro akaratidzwa mundiro pachayo.
- Uchishandisa bhatani re "Delete", unogona kuita kubviswa kwemutsara chaiwo.
- Mushure mekudzvanya, hwindo rekunyevera rinokosha richaonekwa, iro rinoratidza kuti mutsara wakasarudzwa uchadzimwa. Unofanira kudzvanya "OK".
- Mutsara wakabviswa patafura. Mushure memaitiro ese aitwa, tinya pane "Vhara" chinhu.
- Uyezve, iwe unogona kuigadzira kuitira kuti ndiro iwane kutaridzika kwakanaka.
Nzira yechipiri: kuzadza mafomu nemashoko kubva pahwendefa
Semuenzaniso, tine ndiro ine ruzivo rwekubhadhara.
Chinangwa: kuzadza fomu nedata iri kuitira kuti rigone kudhindwa zviri nyore uye nemazvo. Detailed mirairo inoita seizvi:
- Pane rimwe pepa rekushanda regwaro, tinogadzira fomu risina chinhu.
Zvakakosha kucherechedza kuti kutaridzika kwefomu pachayo kunogona kugadzirwa zvakasununguka kana iwe unogona kudhawunirodha akagadzirira-akagadzirwa mafomu kubva kwakasiyana zvinyorwa.
- Usati watora ruzivo kubva mundiro, unoda kuchinja zvishoma. Tinofanira kuwedzera mbiru isina chinhu kuruboshwe rwetafura yepakutanga. Pano chiratidzo chichaiswa pedyo nemutsara watinoronga kuwedzera kune fomu pachayo.
- Iye zvino tinoda kushandisa kusungirirwa kweplate uye fomu. Kuti tiite izvi, tinoda iyo VLOOKUP opareta. Isu tinoshandisa iyi formula: =VLOOKUP(“x”,Data!A2:G16).
- Kana iwe ukaisa mucherechedzo padivi pemitsetse yakati wandei, saka VLOOKUP opareta anotora chete 1st chiratidzo chawanikwa. Kuti ugadzirise dambudziko iri, unofanirwa kudzvanya-kurudyi pane iyo pepa ine pepa rekutanga uye tinya pane "Source text" chinhu. Muhwindo rinoonekwa, isa kodhi inotevera:
Private Sub Worksheet_Change (ByVal Target As Range)
Dim r As Long
Dim str Se String
Kana Target.Count > 1 Wobva wabuda Sub
Kana Target.Column = 1 Zvadaro
str = Target.Value
Application.EnableEvents = Nhema
r = Masero(Rows.Count, 2).End(xlUp).Row
Range(«A2:A» & r).ClearContents
Target.Value = str
Endai Kana
Application.EnableEvents = Chokwadi
End Sub
- Iyi macro haikubvumidze iwe kuti uise anopfuura imwechete label mukoramu yekutanga.
Mhedziso uye mhedziso pamusoro pekugadzirwa kwefomu.
Isu takaona kuti kune akati wandei marudzi ekugadzira fomu mupepeti yespredishiti. Iwe unogona kushandisa akakosha mafomu ari patepi yekushandisa, kana unogona kushandisa VLOOKUP opareta kuendesa ruzivo kubva mundiro kuenda kufomu. Uyezve, macros anokosha anoshandiswa.