Excel 2003 Macro Tutorial

Iyi tutori inoshandisa kushandisa macro recorder kuti iite macro nyore mu Excel . Dzidzo haifaniri kusika kusika kana kugadzirisa macro uchishandisa VBA editor.

01 ye 05

Kutanga Excel Macro Recorder

Cherechedza: Kuti ubatsirwe pane izvi, tarisa pamufananidzo uri pamusoro.

Nzira iri nyore yekuumba macro mu Excel ndeyokushandisa macro recorder.

Kuti uite kudaro, chengetera Zvishandise> Macros> Rekodi New Macro kubva kumamenu kuti uunze Record Macro dialog box.

02 of 05

The Macro Recorder Options

Cherechedza: Kuti ubatsirwe pane izvi, tarisa pamufananidzo uri pamusoro.

Pane zvine zvingasarudzwa kuti upedze mubhokisi rebhokisi:

1. Zita - ipa yako macro zita rinotsanangura.
2. Shortcut key - (zvisarudzo) zadzai tsamba mune nzvimbo iripo. Izvi zvinokubvumira kuti utange macro nekuchengeta pasi CTRL key uye kuomesa tsamba yakasarudzwa pane keyboard.
3. Store macro in -
   • Sarudzo:
   • bhuku rino rekushanda
     • Iko macro inowanikwa chete mune iyi faira.
   • bhuku idzva rebasa
     • Iyi sarudzo inotanga itsva Excel file. Iyo macro inowanikwa chete mune iyi faira.
   • ibhuku rebasa guru rebasa.
     • Izvi zvinogadzira faira yakavanzwa - Personal.xls - iyo inochengetedza macros yako uye inoita kuti iwanikwe kwauri mune dzose maFiles mafaira
4. Tsanangudzo - (optional) Isa tsanangudzo ye macro.

03 of 05

Excel Macro Recorder

Cherechedza: Kuti ubatsirwe pane izvi, tarisa pamufananidzo uri pamusoro.

Kana wapedza kuisa zvaunogona kuita muMacro Recorder nhauriranobhokisi bhokisi muchitsauko chekutanga chekudzidzisa, tsvaga kuGoogle bhokisi kuti utange macro recorder.

Iyo Stop Recording toolbar inofanira kuonekwawo pane skrini.

The macro rekodi inonyora zvose keystrokes uye kuchitsva kwe mouse. Ita yako macro na:

• achifamba nenzira dzose dzinodiwa.
• Pawakapedza, tora bhodhi rekumisa (duku rebhuruu rekona) paBharna Recording toolbar.
• Kana Iyo Stop Recording toolbar isingawanikwi, tsvaga Zvishandisi> Macros> Kurega Kurejera kubva kumamenu kuti urege kurekodi.

04 of 05

Runing a Macro in Excel

Cherechedza: Kuti ubatsirwe pane izvi, tarisa pamufananidzo uri pamusoro.

Kuti utange macro iwe wakanyora:

• Kana ukasarudza kona shoma pakugadzirisa macro, tora pasi CTRL key pabhodibhokisi uye shandisa ikona yekutsvaga.

Kana zvisina kudaro,

1. Dzvanya Zvishandisi> Macros> Macro kubva kumamenyu kuti uunze Macro dialog box .
2. Sarudza macro kubva pakurongwa rweavo varipo.
3. Dzvanya bhora Run .

05 of 05

Kugadzirisa Macro

Cherechedza: Kuti ubatsirwe pane izvi, tarisa pamufananidzo uri pamusoro.

An Excel macro yakanyorwa mubasa re Visual Basic for Applications (VBA) programming.

Kushandura paIndaneti kana Chechi Muzvikwangwani muMacro dialog box rinotanga VBA mhariri (ona mufananidzo uri pamusoro).

Macro Errors

Kunze kwekunge iwe uchiziva VBA, kudzokorora zvakare macro iyo isingashandi zvakanaka kazhinji ndiyo yakanakisisa sarudzo.