He hoʻomaka kēia kumu aʻo i ka ʻōlelo papahana Excel VBA (Visual Basic for Applications). Ma hope o ke aʻo ʻana iā VBA, hiki iā ʻoe ke hana i nā macros a hana i nā hana āpau ma Excel. E ʻike koke ʻoe e hiki i nā macros ke mālama iā ʻoe i ka manawa he nui ma ka hoʻomaʻamaʻa ʻana i nā hana hou a ʻae iā ʻoe e launa pū me nā mea hoʻohana ʻē aʻe ma ke ʻano maʻalahi.
ʻAʻole i manaʻo ʻia kēia kumu aʻo e lilo i alakaʻi piha i ka ʻōlelo hoʻolālā Excel VBA. ʻO kāna kumu e kōkua i kahi mea hoʻomaka e aʻo pehea e kākau ai i nā macros ma Excel me ka hoʻohana ʻana i ka code VBA. No ka poʻe makemake e aʻo i kēia ʻōlelo papahana i ka hohonu, aia nā puke maikaʻi loa ma Excel VBA. Eia nā mea o ka Excel Visual Basic Tutorial. No nā polokalamu polokalamu hou, makemake nui ʻia e hoʻomaka me ka ʻāpana mua o ke kumu aʻo a hoʻopaʻa pono iā lākou. Hiki i ka poʻe me ka ʻike i ka papahana VBA ke lele pololei i nā kumuhana hoihoi.
- Mahele 1: Hoʻopono helu
- Māhele 2: Nāʻanoʻikepili, nā mea hoʻololi a me nā mea mau
- Mahele 3: Nā ʻāpana
- Mahele 4: Hana a me nā kaʻina hana
- Mahele 5: Nā ʻōlelo kūlana
- Mahele 6: Nā pōʻai
- Māhele 7: Nā mea hana a me nā hana i kūkulu ʻia
- Mahele 8: Ke Ana Hoʻohālike Excel
- Mahele 9: Nā hanana ma Excel
- Mahele 10: VBA Hapa
- Nā laʻana VBA
Hiki ke ʻike ʻia kahi wehewehe kikoʻī o Excel VBA ma ka pūnaewele Microsoft Office.