Ichi chidzidzo chisumo cheExcel VBA (Visual Basic for Applications) mutauro wekuronga. Mushure mekudzidza VBA, iwe unozogona kugadzira macros uye kuita chero chero basa muExcel. Iwe uchakurumidza kuona kuti macros anogona kukuchengetedza nguva yakawanda nekuita otomatiki kudzokorora mabasa uye nekukubvumidza iwe kupindirana nevamwe vashandisi nenzira inoshanduka.
Ichi chidzidzo hachina kuitirwa kuti ive gwara rakazara kune iyo Excel VBA programming mutauro. Chinangwa chayo ndechekubatsira anotanga kudzidza kunyora macros muExcel achishandisa VBA kodhi. Kune avo vanoda kudzidza mutauro wechirongwa ichi mune zvakadzama, kune mabhuku akanakisa paExcel VBA. Izvi zvinotevera zviri mukati meExcel Visual Basic Tutorial. Kune vanotanga programmers, zvinokurudzirwa zvikuru kutanga nechikamu chekutanga chedzidziso uye udzidze ivo mukurongeka. Avo vane ruzivo muVBA programming vanogona kusvetuka vakananga kumisoro yekufarira.
- Chikamu 1: Code Formating
- Chikamu 2: Mhando dzedata, zvinosiyana uye zvinogara
- Chikamu 3: Arrays
- Chikamu 4: Basa uye Sub Procedus
- Chikamu 5: Mamiriro ezvinhu
- Chikamu 6: Matenderera
- Chikamu 7: Vashandi uye vakavakirwa-mukati mabasa
- Chikamu 8: Excel Object Model
- Chikamu 9: Zviitiko muExcel
- Chikamu 10: VBA Zvikanganiso
- VBA mienzaniso
Tsananguro yakadzama yeExcel VBA inogona kuwanikwa paMicrosoft Office webhusaiti.