Lesi sifundo siyisingeniso solimi lokuhlela lwe-Excel VBA (Visual Basic for Applications). Ngemva kokufunda i-VBA, uzokwazi ukudala ama-macros futhi wenze cishe noma yimuphi umsebenzi ku-Excel. Uzobona maduze ukuthi ama-macros angakongela isikhathi esiningi ngokwenza imisebenzi ephindaphindwayo futhi akuvumele ukuthi uhlanganyele nabanye abasebenzisi ngendlela evumelana nezimo.
Lesi sifundo akuhloselwe ukuba umhlahlandlela ophelele wolimi lokuhlela lwe-Excel VBA. Inhloso yayo ukusiza oqalayo ukuthi afunde ukubhala ama-macros ku-Excel esebenzisa ikhodi ye-VBA. Kulabo abafuna ukufunda lolu limi lokuhlela ngokujula okwengeziwe, kunezincwadi ezinhle kakhulu ku-Excel VBA. Okulandelayo okuqukethwe kwe-Excel Visual Basic Tutorial. Kubahleli bezinhlelo abaqalayo, kunconywa kakhulu ukuthi uqale ngesigaba sokuqala sesifundo futhi usifunde ngokulandelana. Labo abanolwazi kuhlelo lwe-VBA bangagxuma baqonde ezihlokweni abazithandayo.
- Ingxenye 1: Ukufometha Ikhodi
- Ingxenye 2: Izinhlobo zedatha, okuguquguqukayo nama-constants
- Ingxenye 3: Ama-arrays
- Ingxenye 4: Umsebenzi kanye Nezinqubo Ezincane
- Ingxenye 5: Izitatimende ezinemibandela
- Ingxenye 6: Imijikelezo
- Ingxenye 7: Ama-Opharetha nemisebenzi eyakhelwe ngaphakathi
- Ingxenye 8: Imodeli Yento ye-Excel
- Ingxenye 9: Imicimbi ku-Excel
- Ingxenye 10: Amaphutha e-VBA
- Izibonelo ze-VBA
Incazelo enemininingwane eminingi ye-Excel VBA ingatholakala kuwebhusayithi ye-Microsoft Office.