Igama "Umcimbi we-Excel»isetshenziselwa ukukhombisa izenzo ezithile ezenziwa umsebenzisi ku-Excel. Isibonelo, uma umsebenzisi eshintsha ishidi lencwadi yokusebenzela, lokhu kuwumcimbi. Ukufaka idatha kuseli noma ukulondoloza incwadi yokusebenzela nakho kuyizehlakalo ze-Excel.
Imicimbi ingaxhunyaniswa neshidi lokusebenzela le-Excel, kumashadi, incwadi yokusebenzela, noma ngokuqondile nohlelo lwe-Excel ngokwalo. Abahleli bangakha ikhodi ye-VBA ezokwenziwa ngokuzenzakalelayo uma kwenzeka umcimbi.
Isibonelo, ukuze ube nokugijima okukhulu ngaso sonke isikhathi uma umsebenzisi eshintsha ishidi ku-Excel, ungakha ikhodi ye-VBA ezosebenza njalo uma kwenzeka umcimbi. IshidiVumela ibhuku lokusebenza.
Futhi uma ufuna ukuthi i-macro isebenze njalo uma uya ekhasini elithile lomsebenzi (isibonelo, Ishidi1), khona-ke ikhodi ye-VBA kufanele ihlotshaniswe nomcimbi Cupha kuleli shidi.
Ikhodi ye-VBA ehloselwe ukuphatha imicimbi ye-Excel kufanele ibekwe ephepheni elifanele noma entweni yencwadi yokusebenzela efasiteleni lomhleli we-VBA (umhleli angavulwa ngokuchofoza I-Alt + F11). Isibonelo, ikhodi okufanele isetshenziswe njalo lapho umcimbi othile wenzeka ezingeni lephepha lokusebenza kufanele ibekwe efasiteleni lekhodi yalelo phepha lokusebenzela. Lokhu kuboniswa emfanekisweni:
Kusihleli Esibonakalayo Esiyisisekelo, ungabuka isethi yazo zonke izehlakalo ze-Excel ezitholakala encwadini yokusebenzela, ekhasini lokusebenza, noma ileveli yeshadi. Vula iwindi lekhodi lento ekhethiwe bese ukhetha uhlobo lwento kumenyu yokudonsela phansi kwesokunxele phezulu ewindini. Imenyu yokudonsela phansi kwesokudla phezulu efasiteleni izobonisa izehlakalo ezichazwe kule nto. Isibalo esingezansi sibonisa uhlu lwezehlakalo ezihlotshaniswa nephepha lokusebenzela le-Excel:
Chofoza umcimbi owufunayo kumenyu yokudonsela phansi engakwesokudla, futhi inqubo izofakwa ngokuzenzakalelayo efasiteleni lekhodi yale nto. Okungaphansi. ekhanda lenqubo Okungaphansi I-Excel ifaka ngokuzenzakalelayo izimpikiswano ezidingekayo (uma zikhona). Okusele nje ukwengeza ikhodi ye-VBA ukuze kutholwe ukuthi yiziphi izenzo okufanele zenziwe uma umcimbi ofunekayo utholwa.
Isibonelo
Esibonelweni esilandelayo, isikhathi ngasinye lapho kukhethwa iseli B1 ekhasini lokusebenza Ishidi1 kuvela ibhokisi lemiyalezo.
Ukuze senze lesi senzo, sidinga ukusebenzisa umcimbi weshidi lokusebenzela Ukukhetha_Ushintsho, okwenzeka ngaso sonke isikhathi lapho kushintsha ukukhethwa kweseli noma uhla lwamaseli. Umsebenzi Ukukhetha_Ushintsho ithola njengengxabano Target into -. Lena yindlela esazi ngayo ukuthi yiluphi uhla lwamaseli olukhethiwe.
Indawo Ukukhetha_Ushintsho kwenzeka nganoma yikuphi ukukhetha okusha. Kodwa sidinga isethi yezenzo okufanele yenziwe kuphela uma iseli likhethiwe B1. Ukuze senze lokhu, sizolandelela umcimbi kuphela ebangeni elishiwo Target. Isetshenziswa kanjani kukhodi yohlelo eboniswe ngezansi:
'Ikhodi yokubonisa ibhokisi lemiyalezo uma iseli B1 ikhethiwe 'ephepheni lokusebenzela lamanje. I-Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'Hlola ukuthi ingabe iseli B1 ikhethiwe Uma I-Target.Count = 1 Futhi Target.Row = 1 Futhi Target.Ikholomu = 2 Bese 'Uma iseli B1 ikhethiwe, yenza lokhu okulandelayo MsgBox "Unayo ukhethe iseli B1" End If End Sub