01 ye 01
Dzivirira Invalid Data Entry
Kushandisa Dhigiridziro Dhizinesi Kudzivirira Invalid Data Entry
Zvimwe zvinoshandiswa zveCexcel zvekugadzirisa deta zvinogona kushandiswa kudzora rudzi uye kukosha kwedhesi rakapinda mumasero chaiwo mune pepa rekushanda .
Maitiro akasiyana-siyana ekudzora anogona kushandiswa anosanganisira:
- kuratidza mharidzo inokurumidza apo sero ine mitsara yekugadzirisa deta yakaiswa pane asi pasina mitsara ye data pane sero pachayo
- kudzivirira rudzi uye mararamiro ezvinyorwa zvinogona kupinda muchitokisi
- vachishandisa shanduro iri mune imwe nzvimbo kuti vaone kana data yakapinda musero yakakodzera
Iyi tutori inoshandisa nzira yechipiri yekudzivirira rudzi uye mararamiro ezvinyorwa zvinogona kupinda muchitokisi mune imwe shanduro yekushanda ye Excel.
Kushandisa Error Alert Message
Mukuwedzera pakuisa mitemo kune data inogona kuiswa muchitokisi, Mharidzo yeAlert Alert inogona kuratidzirwa kurondedzera zvinorehwa kana zvisina kubvumirwa dheji.
Kune mhando mitatu yekukanganisa kwakanganisa iyo inogona kuratidzwa uye rudzi rwakasarudzwa runoita kuti zvakanyanyiswa zvinoregererwa sei:
- Mira - inodzivirira kupinda kwe data isina kuwanikwa
- Yambiro - inonyevera kuti dambudziko risina kuwanikwa rakapinda muchitokisi rine chisarudzo chokudarika zviremera
- Ruzivo - inozivisa vashandisi kuti dambudziko risina kuwanikwa rakapinda muchitokisi asi harinodziviriri kupinda kwayo
Mhosva yeZvero Zvisiri
Mhosva Nyevero dzinoratidzwa chete kana deta iri kuiswa muchitokisi. Havaiti kana:
- data isina kubhadhara inopihwa muchitokisi kana kupinda kupinda kushandiswa kugadzirisa
- chirevo mumusero chichiverenga chimwe chinhu chisina kuwanikwa
- a macro inopinda dambudziko risina kuwanikwa muchikamu
Muenzaniso: Kudzivirira kusina kuwanikwa kweDhina
Sezvinoratidzwa mumufananidzo uri pamusoro, muenzaniso uyu unoti:
- sarudza zvigadziridzo zvekugadzirisa dhiyabhorosi izvo zvinobvumira nhamba dzose dzakakwana nehuwandu hwepasi pe5 kuti dzipinde muchitokisi D1;
- kana dambudziko risingabhadharwi rakapinda muchitokisi, A Stop error alert inoratidzwa.
Kuvhura Dhigiriro reDatai Bhokisi reDhialog
Zvose zvinoshandiswa pakugadzirisa mafaira mu Excel zvinoshandiswa uchishandisa dhiyabvumirano yebhokisi yebhokisi .
- Dzvanya pachitokisi D1 - nzvimbo iyo kugadziriswa kwe data kuchashandiswa
- Dzvanya paData Data tab
- Sarudza Kugadzirisa Dhiyabhoni kubva kubhoni kuti uzarure pasi rezasi
- Dzvanya kuVhidhiyo yeDhiyabhorosi muchirongwa kuti uzarure dhiyabvumirano yebhokisi yebhokisi
The Settings Tab
Aya matanho anochengetedza rudzi rwe data inogona kuiswa muchitokisi D1 kusvika kune nhamba dzose dzakakosha zvishoma pasi pechishanu.
- Dzvanya pane Zvirongwa tab mubhokisi rebhokisi
- Pasi Pechibvumirano: sarudzo sarudza Whole Number kubva pakurongwa
- Pasi paData: sarudzo sarudza zvishoma pane kubva pakurongwa
- Mune Maximum: mhando yemutsetse nhamba 5
The Error Alert Tab
Aya matanho anojekesa kuti rudzi rwekanganiso yakangwarira kuratidzwa uye mharidzo yayo ine.
- Dzvanya paAkaita Alert tab mubhokisi rebhokisi
- Iva nechokwadi chekuti "Ratidza mazano ekukanganisa mushure mokunge dare risina kupinda" bhokisi rinotariswa
- Pasi pemutambo : sarudzo sarudza Isa kubva pakurongwa
- Mutsamba : Rudzi rwemutsara: Invalid Data Value
- Muchikanganiso chemashoko: Rudzi rwemitsara: Nhamba chete ine kukosha kwepasi pe5 dzinobvumirwa muchitokisi ichi
- Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda
Kuedza Zvirongwa Zvekugadzirisa Dhiyabhorosi
- Dzvanya pane cell D1
- Tora nhamba ye 9 mu cell D1
- Dhinda pikicha inopinda mubhokisi
- The Stop Stop error message box box inofanira kuonekwa pachikwangwani sezvo nhamba iyi yakakura kudarika huwandu hunoiswa mubhokisi rebhokisi
- Dzvanya paItry button pane bhokisi remashoko rekukanganisa
- Tora nhamba 2 muchikamu D1
- Dhinda pikicha inopinda mubhokisi
- Dheedhi inofanira kugamuchirwa muchitokisi sezvo ichiri pasi pehuwandu hunotarirwa mubhokisi rebhokisi