Contents
ʻO Arrays ma Visual Basic for Application he mau hale e mālama maʻamau i nā pūʻulu o nā ʻano like ʻole o ke ʻano like. Loaʻa ʻia nā helu helu e kā lākou helu helu.
No ka laʻana, aia kahi hui o 20 poʻe e pono e mālama ʻia ko lākou mau inoa no ka hoʻohana hope ʻana i ka code VBA. Hiki i kekahi ke haʻi wale i 20 mau ʻano e paʻa i kēlā me kēia inoa, e like me:
Kaumaha Hui_Member1 As String Dim Team_Member2 As String ... Kaumaha Hui_Member20 As String
Akā hiki iā ʻoe ke hoʻohana i kahi ala ʻoi aku ka maʻalahi a ʻoi aku ka maikaʻi - mālama i kahi papa inoa o nā inoa lālā o ka hui ma kahi ʻano o 20 mau ʻano like. kaula:
Hoʻomaʻamaʻa i nā lālā_hui (1 a 20) ma ke ʻano he string
Ma ka laina i hōʻike ʻia ma luna, ua haʻi mākou i kahi array. I kēia manawa, e kākau i kahi waiwai i kēlā me kēia o kāna mau mea, e like me kēia:
Hui_Members(1) = "John Smith"
ʻO kahi pōmaikaʻi ʻē aʻe o ka mālama ʻana i ka ʻikepili i loko o kahi laha, i hoʻohālikelike ʻia me ka hoʻohana ʻana i nā ʻano like ʻole, e ʻike ʻia inā pono e hana i ka hana like ma kēlā me kēia mea o ka laha. Inā mālama ʻia nā inoa o nā lālā o ka hui i 20 mau ʻokoʻa like ʻole, a laila pono e kākau i nā laina code 20 i kēlā me kēia manawa e hana i ka hana like ma kēlā me kēia o lākou. Eia nō naʻe, inā mālama ʻia nā inoa i kahi ʻano, a laila hiki iā ʻoe ke hana i ka hana i makemake ʻia me kēlā me kēia me ka hoʻohana ʻana i kahi loop maʻalahi.
Hōʻike ʻia ke ʻano o ka hana ʻana ma lalo me kahi laʻana code e paʻi ana i nā inoa o kēlā me kēia lālā o ka hui ma ke kaʻina o nā kolamu. A pepa hana Excel hana.
No ka i = 1 a 20 Kelepona(i,1). Waiwai = Hui_Member(i) Aʻe i
ʻOiaʻiʻo, ʻoi aku ka liʻiliʻi o ka paʻakikī a me ka pololei ma mua o ka hoʻohana ʻana me 20 mau inoa ʻokoʻa. Akā pehea inā ʻaʻole 20 kēia mau inoa, akā 20? A inā, he mea hou aku, pono e mālama kaʻawale i nā inoa inoa a me nā patronymics?! ʻIke ʻia e lilo koke ia i mea hiki ʻole ke mālama i ka nui o ka ʻikepili i ka code VBA me ke kōkua ʻole o kahi ʻano.
ʻO nā pūʻulu multidimensional ma Excel Visual Basic
ʻO nā papa kuhikuhi Visual Basic i kūkākūkā ʻia ma luna nei i manaʻo ʻia he hoʻokahi. ʻO ia hoʻi, mālama lākou i kahi papa inoa maʻalahi. Eia nō naʻe, hiki i nā arrays ke loaʻa i nā ana he nui. No ka laʻana, hiki ke hoʻohālikelike ʻia kahi ʻāpana ʻelua me ka pā o nā waiwai.
E ʻōlelo mākou makemake ʻoe e mālama i nā helu kūʻai i kēlā me kēia lā no Ianuali no 5 mau hui like ʻole. Pono kēia i kahi ʻāpana ʻelua-dimensional i loaʻa i nā ʻāpana 5 o nā metric no 31 mau lā. E haʻi aku i kahi array e like me kēia:
Hōʻalo Jan_Sales_Figures(1 a 31, 1 a 5) e like me ke kālā
No ke komo ʻana i nā mea hoʻonohonoho Jan_Sales_Figures, pono ʻoe e hoʻohana i ʻelua mau kuhikuhi e hōʻike ana i ka lā o ka mahina a me ka helu kauoha. No ka laʻana, ka helu wahi o kahi mea i loaʻa nā helu kūʻai no 2-oh hui no 15 th E kākau ʻia ʻo Ianuali penei:
Jan_Sales_Figures(15, 2)
Ma ke ala like, hiki iā ʻoe ke haʻi aku i kahi laha me 3 a ʻoi aku paha nā ana - e hoʻohui wale i nā ana ʻē aʻe i ka ʻōlelo hoʻolaha a hoʻohana i nā kuhikuhi hou e kuhikuhi i nā mea o kēia ʻano.
Hoʻolaha ʻana i nā ʻāpana ma Excel Visual Basic
Ma mua o kēia ʻatikala, ua nānā mākou i kekahi mau hiʻohiʻona o ka haʻi ʻana i nā arrays ma VBA, akā pono kēia kumuhana e nānā pono. E like me ka mea i hōʻike ʻia, hiki ke haʻi ʻia kahi ʻāpana hoʻokahi e like me kēia:
Hoʻomaʻamaʻa i nā lālā_hui (1 a 20) ma ke ʻano he string
Hōʻike ʻia kēlā ʻōlelo i ka VBA compiler i ka array Hui_Laa Aia i loko o 20 mau mea hoʻololi i hiki ke kiʻi ʻia ma nā helu mai ka 1 a hiki i ka 20. Eia naʻe, manaʻo paha mākou i ka helu ʻana i kā mākou ʻano hoʻololi mai ka 0 a hiki i ka 19, a laila e haʻi ʻia ka array penei:
Hoʻomaʻamaʻa i nā lālā_hui (0 a 19) ma ke ʻano he string
ʻO kaʻoiaʻiʻo, ma ka maʻamau, hoʻomaka ka helu ʻana i nā mea hoʻonohonoho mai ka 0, a ma ka ʻōlelo hoʻolaha, ʻaʻole hiki ke kuhikuhi ʻia ka papa kuhikuhi mua, e like me kēia:
ʻAʻohe hui_nā lālā(19) ma ke ʻano he string
E mālama ka VBA compiler i kēlā ʻano helu e like me ka haʻi ʻana i kahi ʻano o 20 mau mea me nā helu mai 0 a 19.
Hoʻohana ʻia nā lula like i ka wā e haʻi ʻia ana i nā array Visual Basic multidimensional. E like me ka mea i hōʻike mua ʻia ma kekahi o nā laʻana, i ka wā e haʻi ana i kahi ʻāpana ʻelua-dimensional, ua hoʻokaʻawale ʻia nā helu o kona mau ana e kahi koma:
Hōʻalo Jan_Sales_Figures(1 a 31, 1 a 5) e like me ke kālā
Eia naʻe, inā ʻaʻole ʻoe e kuhikuhi i kahi kuhikuhi hoʻomaka no nā ʻāpana ʻelua o ka array a haʻi ʻia e like me kēia:
Dim Jan_Sales_Figures(31, 5) E like me ke kālā
a laila e mālama ʻia kēia komo ʻana ma ke ʻano he ʻāpana ʻelua, ʻo ka anana mua he 32 mau mea me nā helu mai ka 0 a hiki i ka 31, a ʻo ka ʻāpana ʻelua o ka papa he 6 mau mea me nā helu mai 0 a 5.
Nā hoʻonohonoho Dynamic
Loaʻa nā ʻāpana āpau i nā laʻana i luna i ka helu paʻa o nā ana. Eia naʻe, i nā manawa he nui ʻaʻole mākou i ʻike mua i ka nui o kā mākou array. Hiki iā mākou ke haʻalele i ke kūlana ma ka haʻi ʻana i kahi ʻano nui, ʻoi aku ka nui o ka nui ma mua o ka pono no kā mākou hana. Akā ʻo ia ʻano hoʻonā e koi i ka nui o ka hoʻomanaʻo hou a hiki ke hoʻolōʻihi i ka papahana. Aia kahi ʻoi aku ka maikaʻi. Hiki iā mākou ke hoʻohana i kahi array dynamic - he ʻano kēia i hiki ke hoʻonohonoho ʻia ka nui a hoʻololi i kekahi mau manawa i ka wā o ka hoʻokō ʻana i kahi macro.
Hōʻike ʻia kahi array dynamic me nā pani hakahaka, e like me kēia:
Hoʻomaʻamaʻa i nā lālā_hui () ma ke ʻano he string
A laila, pono ʻoe e haʻi i ka nui o ka array i ka wā o ka hoʻokō code me ka hoʻohana ʻana i ka ʻōlelo ReDim:
ReDim Team_Members(1 a 20)
A inā i ka wā e hoʻokō ai i ke code pono ʻoe e hoʻololi hou i ka nui o ka array, a laila hiki iā ʻoe ke hoʻohana hou i ka ʻōlelo ReDim:
Inā Hui_Size > 20 A laila e hoʻopau i nā hui_members(1 i ka nui_hui)
E hoʻomanaʻo i ka hoʻololi ʻana i kahi array dynamic ma kēia ala e hopena i ka nalowale o nā waiwai āpau i mālama ʻia i ka array. No ka mālama ʻana i ka ʻikepili i loko o ka laha, pono ʻoe e hoʻohana i ka huaʻōlelo E mālamae like me ia i hōʻikeʻia i lalo:
Inā Hui_Size > 20 A laila e ho'opa'a hou i nā hui_members(1 i ka nui_hui) pau inā
Minamina ka hua'ōlelo E mālama hiki ke hoʻohana wale ʻia no ka hoʻololi ʻana i ka palena o luna o kahi ʻāpana array. ʻAʻole hiki ke hoʻololi ʻia ka palena haʻahaʻa o kahi ʻano. Eia kekahi, inā he nui nā ana o ka array, a laila e hoʻohana i ka huaʻōlelo E mālama, hiki ke hoʻololi ʻia ka nui hope o ka laha.