Excel 2003 Macro Tutorial

Phunziro ili likugwiritsira ntchito zolemba zazikulu kuti apange macro osavuta ku Excel . Phunziro silikuphimba kulenga kapena kusintha macro pogwiritsa ntchito mkonzi wa VBA.

01 ya 05

Kuyambira Excel Macro Recorder

Zindikirani: Kuti muthandizidwe pazitsulo izi, yang'anani pa chithunzi pamwambapa.

Njira yosavuta yopanga macro mu Excel ndiyo kugwiritsa ntchito zojambula zazikulu.

Kuti muchite zimenezi, dinani Zida> Macros> Record New Macro kuchokera m'ma menus kuti mubweretse Record Macro dialog box.

02 ya 05

Macro Recorder Options

Zindikirani: Kuti muthandizidwe pazitsulo izi, yang'anani pa chithunzi pamwambapa.

Pali njira zinayi zomwe mungakwaniritse mu bokosi ili:

1. Dzina - perekani dzina lanu lofotokozera.
2. Mfungulo wadule - (mungakonde) lembani kalata m'malo omwe alipo. Izi zidzakulolani kuti muthe kuyendetsa masewerawa polemba chilembo cha CTRL ndikusindikiza kalata yosankhidwa pa makiyi.
3. Sungani macro -
   • Zosankha:
   • bukhu la ntchito yamakono
     • Zambirizi zimapezeka pokhapokha mu fayilo iyi.
   • Buku latsopano
     • Njirayi ikutsegula fayilo yatsopano ya Excel. Zachilendozi zimapezeka kokha pa fayilo yatsopanoyi.
   • bukhu lakugwira ntchito lalikulu.
     • Njirayi imapanga mafayilo obisika - Personal.xls - omwe amasungira macros anu ndikuwapangitsani inu maofesi onse a Excel
4. Kufotokozera - (zosankha) Lowani tsatanetsatane wa macro.

03 a 05

Zolemba Zojambula Zojambula

Zindikirani: Kuti muthandizidwe pazitsulo izi, yang'anani pa chithunzi pamwambapa.

Mukamaliza kusankha zochita zanu mu bokosi la zokambirana la Macro muzithunzi zapitazo, dinani botani loyenera kuti muyambe kujambula.

Chotsegula Toolbar Choyimira chiyenera kuwonanso pawindo.

Zojambula zazikulu zimakumbukira zovuta zonse ndi kuwongolera kwa mbewa. Pangani macro anu ndi:

• Pogwiritsa ntchito njira zonse zofunika.
• Mukamaliza, dinani batani loyimira (bwalo laling'ono la buluu) pa barabu yotsalira ya Stop Recording .
• Ngati Chojambulira Chojambulira Chojambulira Sichipezeka , dinani Zida> Macros> Lekani Kujambula kuchokera kumamenyu kuti musiye kujambula.

04 ya 05

Kuthamanga Macro ku Excel

Zindikirani: Kuti muthandizidwe pazitsulo izi, yang'anani pa chithunzi pamwambapa.

Kuti muyambe macro omwe mwalemba:

• Ngati munasankha fungulo lachidule pamene mukupanga macro, gwiritsani chingwe cha CTRL pa kibokosiko ndikusindikizira fungulo lachidule.

Apo ayi,

1. Dinani Zida> Macros> Macro kuchokera m'ma menus kuti mubweretse bokosi la zokambirana za Macro .
2. Sankhani macro kuchokera mndandanda wa omwe alipo.
3. Dinani pa batani.

05 ya 05

Kusintha Macro

Zindikirani: Kuti muthandizidwe pazitsulo izi, yang'anani pa chithunzi pamwambapa.

An Excel macro yalembedwa m'chinenero cha ma Visual Basic for Applications (VBA).

Kuphatikiza pa Kusintha kapena Khwerelo Muzitsulo mu bokosi la zokambirana la Macro limayambitsa mkonzi wa VBA (onani chithunzi pamwambapa).

Zolakwa za Macro

Pokhapokha mutadziwa VBA, kubwezeretsanso zinthu zambiri zomwe sizigwira ntchito nthawi zambiri ndizo zabwino kwambiri.