Excel 2003 i-Macro Tutorial

Le tutorial igubungela ukusebenzisa irekhodi enkulu ukwenza i-macro elula kwi- Excel . I-tutorial ayifihla ukudala okanye ukuhlela i-macro usebenzisa umhleli we-VBA.

01 ngo 05

Ukuqala i-Excel Macro Recorder

Qaphela: Uncedo kumanqanaba, bhekisa kumfanekiso ongentla.

Indlela elula yokudala i-macro kwi-Excel kukusebenzisa irekhodi enkulu.

Ukwenza njalo, nqakraza izixhobo> Macros> Rekhoda iNew Macro ukusuka kwimenyu ukukhupha ibhokisi yencoko ye-Record Macro.

02 we 05

Izinketho ze-Macro Recorder

Qaphela: Uncedo kumanqanaba, bhekisa kumfanekiso ongentla.

Kukho iindlela ezine zokugqiba kule bhokisi yencoko:

1. Igama - linika igama lakho elichazayo.
2. Iqhosha lokunciphisa - (ukhetho) gcwalisa ileta kwindawo ekhoyo. Oku kuya kukuvumela ukuba usebenze i-macro ngokubamba phantsi iqhosha le CTRL kwaye ucinezela ileta ekhethiweyo kwibhodibhodi.
3. Gcina i - macro
   • Khetha:
   • yencwadi yangoku
     • I-macro iyatholakala kuphela kule fayili.
   • incwadi entsha yomsebenzi
     • Olu khetho luvula ifayile entsha ye-Excel. I-macro iyatholakala kuphela kule fayile entsha.
   • ibhuku lomsebenzi lomntu.
     • Olu khetho ludala ifayile efihliweyo - Personal.xls - egcina ii-macros zakho kwaye yenza ukuba zifumaneke kuzo zonke iifayile ze-Excel
4. Inkcazelo - (ukhetho) Faka inkcazo ye-macro.

03 we 05

I-Excel Macro Recorder

Qaphela: Uncedo kumanqanaba, bhekisa kumfanekiso ongentla.

Xa ugqibile ukubeka iinketho zakho kwibhokisi yencoko yababhali be - Macro kwinqanaba langaphambili lale tutorial, nqakraza iqhosha le-OK ukuqala irekhodi le-macro.

I- Bar Stop toolbar nayo kufuneka ibonakale kwisikrini.

Umrekhoda omkhulu urekhoda zonke iifayile kunye nokuchofoza kwe mouse. Yenza i-macro yakho ngu:

• ngokuzenzekelayo ukuhamba kuwo onke amanyathelo afanelekileyo.
• Xa uqedile, nqakraza iqhosha lokuma (encinci yesikwere esibhakabhaka) kwiBar yokutyelela ibha yokurekhoda .
• Ukuba iBar Toolbar yokurekhoda ayitholakali, qhafaza Izixhobo> Macros> Yeka Ukurekhoda ukusuka kwimenyu ukuyeka ukurekhoda.

04 we 05

Ukuqalisa iMacro kwi-Excel

Qaphela: Uncedo kumanqanaba, bhekisa kumfanekiso ongentla.

Ukuqhuba i-macro oyibhalileyo:

• Ukuba ukhethe ikhetho elifutshane ekudaleni i-macro, ubambe iqhosha le CTRL kwikhibhodi uze ucine iqhosha lokuncinci .

Ngaphandle koko,

1. Cofa Izixhobo> Macros> Macro ukusuka kwimenyu ukukhupha ibhokisi yencoko ye-Macro .
2. Khetha i-macro kuluhlu lwazo zikhoyo.
3. Cofa iqhosha le Run .

05 we 05

Ukuhlela iMacro

Qaphela: Uncedo kumanqanaba, bhekisa kumfanekiso ongentla.

I-Excel macro ibhaliwe kwiilwimi zoLwimi lweValual Basic Applications (VBA).

Ukuchofoza kwi-Hlela okanye Isinyathelo Kwiibhokisi kwibhokisi yencoko ye-Macro iqalisa umhleli we-VBA (bona umfanekiso ophezulu).

Iimpazamo zeMacro

Ngaphandle kokuba uyayazi i-VBA, ukurekhoda kwakhona i-macro engasebenzi kakuhle yinto ekhethekileyo.