ʻO ka hua'ōlelo "hanana Excel» hoʻohana ʻia e hōʻike i kekahi mau hana i hana ʻia e ka mea hoʻohana ma Excel. No ka laʻana, ke hoʻololi ka mea hoʻohana i kahi pepa hana, he hanana kēia. ʻO ka hoʻokomo ʻana i ka ʻikepili i loko o ke kelepona a i ʻole ka mālama ʻana i kahi puke hana he mau hanana Excel kekahi.
Hiki ke hoʻopili ʻia nā hanana i kahi pepa haʻawina Excel, i nā pakuhi, kahi puke hana, a i ʻole pololei i ka palapala Excel ponoʻī. Hiki i nā polokalamu polokalamu ke hana i ka code VBA e hoʻokō ʻia i ka wā e loaʻa ai kahi hanana.
No ka laʻana, no ka holo ʻana o ka macro i kēlā me kēia manawa e hoʻololi ka mea hoʻohana i kahi pepa haʻawina ma kahi puke haʻawina Excel, hana ʻoe i ka code VBA e holo ana i kēlā me kēia manawa i ka hanana. SheetActivate puke hana.
A inā makemake ʻoe e holo ka macro i kēlā me kēia manawa āu e hele ai i kahi pepa haʻawina kikoʻī (no ka laʻana, Sheet1), a laila pono e pili ka VBA code me ka hanana haʻalele no keia pepa.
Pono e hoʻokomo ʻia ka code VBA i manaʻo ʻia e lawelawe i nā hanana Excel i ka pepa haʻawina kūpono a i ʻole mea hana puke ma ka puka makani hoʻoponopono VBA (hiki ke wehe ʻia ka mea hoʻoponopono ma ke kaomi ʻana. Alt + F11). No ka laʻana, pono e hoʻokomo ʻia ke code e hoʻokō ʻia i kēlā me kēia manawa i loaʻa kekahi hanana ma ka pae haʻawina e kau ʻia ma ka pukaaniani code no kēlā pepa haʻawina. Hōʻike ʻia kēia ma ke kiʻi:
Ma ka mea hoʻoponopono Visual Basic, hiki iā ʻoe ke nānā i ka hoʻonohonoho o nā hanana Excel āpau i loaʻa ma ka puke haʻawina, pepa haʻawina, a i ʻole pae kiʻi. E wehe i ka puka makani code no ka mea i koho ʻia a koho i ke ʻano mea mai ka papa kuhikuhi hema ma ka piko o ka pukaaniani. E hōʻike ʻia nā hanana i wehewehe ʻia no kēia mea ma ka papa kuhikuhi hāʻule ʻākau ma luna o ka pukaaniani. Hōʻike ka kiʻi ma lalo nei i kahi papa inoa o nā hanana i pili me kahi pepa hana Excel:
Kaomi ma ka hanana i makemake ʻia ma ka papa kuhikuhi hāʻule ʻākau, a e hoʻokomo ʻia kahi kaʻina hana i loko o ka puka makani code no kēia mea. iiaciiie. ma ke poʻo o ke kaʻina hana iiaciiie Hoʻokomo maʻalahi ʻo Excel i nā manaʻo i koi ʻia (inā loaʻa). ʻO nā mea a pau e hoʻohui i ka code VBA e hoʻoholo ai i nā hana e pono ai ke kaʻina hana ke ʻike ʻia ka hanana i makemake ʻia.
la'ana
Ma kēia laʻana, i kēlā me kēia manawa ke koho ʻia kahi kelepona B1 ma ka pepa hana Sheet1 puka mai kahi pahu memo.
No ka hana ʻana i kēia hana, pono mākou e hoʻohana i ka hanana pepa haʻawina Koho_Hoololi, e loaʻa ana i kēlā me kēia manawa ke hoʻololi ʻia ke koho ʻana o kahi cell a i ʻole ka laulā o nā cell. Hana Koho_Hoololi loaa he hoopaapaa pale umauma hoʻokahi mea -. Pēlā mākou e ʻike ai i ke ʻano o nā cell i koho ʻia.
hanana Koho_Hoololi hiki mai me kekahi koho hou. Akā pono mākou i ka hoʻonohonoho o nā hana e hoʻokō wale ʻia ke koho ʻia ke kelepona B1. No ka hana ʻana i kēia, e hahai mākou i ka hanana wale nō ma ka pae i kuhikuhi ʻia pale umauma hoʻokahi. Pehea e hoʻokō ʻia ai i ka code program i hōʻike ʻia ma lalo nei:
'Code e hōʻike i kahi pahu memo ke koho ʻia ke kelepona B1 'ma ka pepa haʻawina o kēia manawa. Private Sub Worksheet_SelectionChange(ByVal Target As Range) 'E nānā inā koho ʻia ka cell B1 Inā Target.Count = 1 A me Target.Row = 1 A me Target.Column = 2 A laila 'Inā koho ʻia ka cell B1, a laila e hana i kēia MsgBox "Loaʻa iā ʻoe. koho ʻia kahi cell B1" End If End Sub