Kuyaziwa ukuba kwimeko yesiqhelo, izihloko zekholamu kwiNkqubo ye-Excel zichazwa ngoonobumba abanobumba besiLatin. Kodwa, ngaxa lithile, umsebenzisi unokufumana loo nto ngoku iikholamu ziboniswe ngamanani. Oku kungenzeka ngenxa yezizathu ezininzi: Iindidi ezahlukeneyo zenkqubo yokungasebenzi kakuhle, iintshukumo ezingacacanga, ukutshintshwa ngenjongo yomnye umsebenzisi, njl. Kodwa, zeziphi izinto ezibangela ukuba kungenzeka, xa kwenzeka imeko efanayo, umbuzo wokubuyiswa kwamagama eekholamu kumhlaba oqhelekileyo ubalulekile. Masifumanise ukuba ungawatshintshela njani amanani kwiileta ezikwi-Excel.
Ibonisa ukhetho lokutshintsha
Zimbini iindlela zokhetho lokuzisa ipaneli elungelelanisiweyo kwingqondo yesiqhelo. Enye yazo iqhutywa kwi-Interge umfanekiso, kwaye okwesibini kuthetha ukuba umyalelo wokuyalela usebenzisa ikhowudi. Cinga ngolwazi ngakumbi zombini iindlela.
Indlela yoku-1: Usebenzisa i-interface yenkqubo
Eyona ndlela ilula yokutshintsha ukuboniswa kwamagama eekholamu ngenani ngoonobumba ngalunye kukusebenzisa izixhobo zenkqubo ngqo.
- Senza inguqu kwi "Ifayile" yethebhu.
- Sifudukela kwicandelo "leParameter".
- Kwinkqubo yeeparameters zenkqubo ezivula, yiya kwicandelwana elithi "ifomula".
- Emva kokutshintsha kwinxalenye ephakathi yefestile, sifumana "umsebenzi nge-formulas" yebhloko. Malunga neparamitha ye-R1C1 isungula i-tick. Cofa kwiqhosha "Kulungile" emazantsi efestile.
Ngoku igama leekholamu kwiphaneli yokulungelelanisa liyakuthatha inkangeleko eqhelekileyo kuthi, oko kukuthi, iya kumakishwa ngoonobumba.
Indlela 2: Ukusetyenziswa kweMacro
Inketho yesibini njengesisombululo kwingxaki ibandakanya ukusetyenziswa kweMacro.
- Yenza i-Poider Poiper kwi-tepi, ukuba iphuhlisiwe. Ukwenza le nto, yenza ukuba ifuduke "kwifayile" yethebhu. Emva koko, sicofa umbhalo "weparamitha".
- Kwifestile evula, khetha i-ribbon yento yokuseta. Kwicala lasekunene lefestile, sibeke into ekufutshane ne "Musile". Cofa kwiqhosha "Kulungile". Ke, indlela yovelwano ivuliwe.
- Yiya kwithebhu yovelwano. Sicofa iqhosha "elisiseko" esisiseko, elibekwe kumda osekhohlo weteyiphu kwibhloko "yeKhowudi". Awunakho ukuvelisa ezi ntshukumo kwiteyiphu, kodwa ucofe iqhosha le-iholo kwi-Alt + F11 ikhibhodi.
- Umhleli weVBA uyavula. Cofa kwikhibhodi ukudityaniswa kwe-CTRL + G izitshixo. Kwifestile evula, faka ikhowudi:
Isicelo.resflecle = xla1
Cofa kwiqhosha lokungena.
Emva kwezi zenzo, ukuboniswa kwe-alfabhethi zegama lekholamu yeshiti kuya kubuya, ukutshintsha ukhetho lwamanani.
Njengoko ubona, ukutshintsha okungalindelekanga kwegama lekholamu kunxibelelanisa ileta ukuya kuthi ga kwinombolo akufuneki ifakwe kwisiphelo somsebenzisi. Yonke into ilula kakhulu ukubuyela kwimeko yangaphambili ngotshintsho kwiiparamitha ze-Excel. Ukukhetha usebenzisa i-macro kuyavakala ukuba ufaka kuphela ukuba ngesizathu esithile awungekhe usebenzise indlela esemgangathweni. Umzekelo, ngenxa yohlobo oluthile lokusilela. Ewe kunjalo, unokufaka olu khetho ngeenjongo zokuvavanywa ukuze ubone nje indlela uhlobo lokutshintsha olusebenzayo.