Maphunzirowa ndi mawu oyamba a chilankhulo cha Excel VBA (Visual Basic for Applications). Pambuyo pophunzira VBA, mudzatha kupanga macros ndikuchita pafupifupi ntchito iliyonse mu Excel. Mudzazindikira posachedwa kuti ma macros amatha kukupulumutsirani nthawi yochuluka pochita ntchito zobwerezabwereza ndikukulolani kuti muzitha kulumikizana ndi ogwiritsa ntchito ena mosinthika.
Maphunzirowa sanapangidwe kuti akhale chiwongolero chokwanira cha chilankhulo cha Excel VBA. Cholinga chake ndi kuthandiza woyambitsa kuphunzira kulemba macros mu Excel pogwiritsa ntchito VBA code. Kwa iwo omwe akufuna kuphunzira chilankhulo cha pulogalamuyo mozama, pali mabuku abwino kwambiri pa Excel VBA. Zotsatirazi ndi zomwe zili mu Excel Visual Basic Tutorial. Kwa opanga mapulogalamu a novice, ndi bwino kuti tiyambe ndi gawo loyamba la phunziroli ndikuziphunzira mwadongosolo. Omwe ali ndi chidziwitso pakupanga mapulogalamu a VBA amatha kulumpha molunjika kumitu yosangalatsa.
- Gawo 1: Kusintha Ma Code
- Gawo 2: Mitundu ya data, zosinthika ndi zokhazikika
- Gawo 3: Zosanjikiza
- Gawo 4: Ntchito ndi Njira Zochepa
- Gawo 5: Mawu okhazikika
- Gawo 6: Mizungu
- Gawo 7: Othandizira ndi ntchito zomanga
- Gawo 8: Chitsanzo cha Zinthu za Excel
- Gawo 9: Zochitika mu Excel
- Gawo 10: VBA Zolakwa
- Zitsanzo za VBA
Kufotokozera mwatsatanetsatane kwa Excel VBA kungapezeke patsamba la Microsoft Office.