No nyeem siv los siv cov macro recorder los ua ib qho yooj yim macro hauv Excel . Tus nyeem tsis npaj los tsim kho lossis siv lub Vro editor.
01 ntawm 05
Pib lub Excel Macro Recorder
Lus Cim: Rau kev pabcuam ntawm cov kauj ruam no, saib ntawm daim duab saum toj no.
Qhov yoojyim tshaj los tsim kom tau ib lub macro nyob hauv Excel yog siv cov ntaub ntawv sau rau ntawm macro.
Kom ua tau li, nias cov cuab yeej> Macros> Sau Tshiab Macro los ntawm cov ntawv teev npe mus nqa cov Ntawv Teev Ntawv Teev Ntawv.
02 ntawm 05
Lub Macro Recorder Options
Lus Cim: Rau kev pabcuam ntawm cov kauj ruam no, saib ntawm daim duab saum toj no.
Muaj plaub qho kev xaiv ua tiav hauv lub thawv ntawv no:
- Lub Npe - muab koj lub npe los piav qhia meej.
- Shortcut key - (optional) sau rau hauv ib tsab ntawv uas muaj chaw seem. Qhov no yuav cia koj khiav lub macro los ntawm tuav lub CTRL qhov tseem ceeb thiab nias lub ntawv xaiv rau ntawm cov keyboard.
- Khw muag khoom nyob rau hauv -
- Xaiv:
- cov ntawv ua haujlwm tam sim no
- Lub macro tsuas muaj nyob hauv cov ntaub ntawv no.
- ib phau ntawv tshiab
- Qhov kev xaiv no qhib Excel ua cov ntaub ntawv tshiab. Lub macro tsuas muaj nyob hauv cov ntaub ntawv tshiab no.
- ib tus kheej ua hauj lwm macro.
- Qhov kev xaiv no ua ib qho ntaub ntawv zais - Personal.xls - uas khaws koj cov macros thiab ua rau lawv muaj nyob rau hauv tag nrho cov ntaub ntawv Excel
- Kev piav qhia - (tsis teb los tau) Sau cov lus piav qhia ntawm qhov kev lag luam.
03 ntawm 05
Excel Macro Recorder
Lus Cim: Rau kev pabcuam ntawm cov kauj ruam no, saib ntawm daim duab saum toj no.
Thaum tiav qhov koj xaiv hauv Macro Recorder lub thawv sib tham hauv lub kauj ruam dhau los ntawm phau ntawv no, nyem qhov khawm kom pib lub tshuab ntaus ntawv.
Lub Nruab Nrab Cov Tsav Tsheb yuav tsum pom ntawm qhov screen.
Macro recorder sau txhua tus keystrokes thiab clicks nas. Ua kom koj lub npe los ntawm:
- manually mus dhau tag nrho cov kauj ruam tsim nyog.
- Thaum tiav lawm, nias lub pob kom nres (me me xiav xwm yeem) ntawm Txoj Cai Kho Nres .
- Yog hais tias Tsis Txuag Cov cuab yeej toolbar tsis muaj, nias cuab yeej> Macros> Txiav Txais Los ntawm daim ntawv teev cov khoom noj kom txhob kaw.
04 ntawm 05
Khiav Macro hauv Excel
Lus Cim: Rau kev pabcuam ntawm cov kauj ruam no, saib ntawm daim duab saum toj no.
Khiav macro koj tau kaw:
- Yog tias koj xaiv qhov tseem ceeb shortcut thaum tsim lub macro, puag tus ntawv CTRL rau ntawm cov keyboard thiab nias ntawm qhov tseem ceeb.
Txwv tsis pub,
- Nyem qhov cuab yeej> Macros> Macro los ntawm cov ntawv teev npe mus rau Macro kev sib tham .
- Xaiv ib qho lag luam los ntawm cov neeg muaj.
- Nyem khawm Run .
05 ntawm 05
Editing ib qho Macro
Lus Cim: Rau kev pabcuam ntawm cov kauj ruam no, saib ntawm daim duab saum toj no.
Ib qho Excel macro yog sau hauv daim duab Basic for Applications (VBA) cov lus programming.
Txhawm rau ntawm Kev Hloov lossis Cov Kauj Ruam Rau Cov Nyees Npe hauv lub Macro kev sib tham pib pib lub VBA editor (saib daim duab saum toj no).
Macro yuam kev
Tshwj tsis yog tias koj paub VBA, rov teev cov ntaub ntawv uas tsis ua haujlwm yog qhov kev xaiv zoo tshaj plaws.