Yuav ua li cas los tsim cov macro hauv excel

Cov macros hauv Microsoft Excel Tso cai rau koj kom ua tau sai sai cov haujlwm nrog cov ntaub ntawv hauv cov lus editor no. Cov yeeb yaj kiab no tau ua tiav los ntawm kev siv cov kev ua kom rov ua dua hauv txoj cai tshwj xeeb. Cia peb xav yuav tsim macros hauv txoj haujlwm thiab seb lawv tuaj yeem hloov kho.

Cov hau kev ntawm sau cov macros hauv Excel

Macro tau sau ua ob txoj kev: cia li thiab tus kheej. Siv thawj qhov kev xaiv, koj tsuas sau qee yam kev ua hauv Microsoft Excel, uas yog tam sim no muaj. Tom qab ntawd koj tuaj yeem ua si nkag no. Hom qauv no yog lub teeb heev thiab tsis tas yuav paub txog txoj cai, tab sis nws siv yog txwv. Los ntawm txhais tes kaw cia, ntawm qhov tsis sib xws, yuav tsum muaj kev paub txog kev ua tiav, raws li txoj cai yog hu ua manuallyboard. Txawm li cas los xij, txoj cai sib tw sau nyob rau hauv txoj kev no tuaj yeem ua kom sai sai ua tiav kev tua ntawm cov txheej txheem.

Qhov Xaiv 1: Tsis siv neeg kaw ntawm macros

Ua ntej pib lub tshuab hluav taws xob ntawm macros, koj yuav tsum ua kom lawv nyob hauv Microsoft Excel Program. Ua li no, siv peb cov khoom siv cais.

Nyeem ntxiv: Ua kom muaj cov macros hauv Microsoft Excel

Thaum txhua yam npaj tiav, npaj mus rau cov ntaub ntawv.

1. Nyem tus tsim tawm tab. Nyem rau ntawm "Macro sau" khawm, uas nyob rau ntawm daim kab xev hauv cov code "code" toolbar.



2. Ib macro kaw cia teeb lub qhov rai qhib. Ntawm no koj tuaj yeem hais txhua lub npe rau nws yog tias lub neej ntawd tsis txaus siab rau koj. Qhov loj tshaj plaws yog tias lub npe nws pib nrog tsab ntawv, thiab tsis yog nrog tus lej, nrog rau hauv lub npe yuav tsum tsis muaj qhov khoob. Peb tawm hauv lub npe hu ua - "Macro1".
3. Tam sim ntawd, yog tias koj xav tau, koj tuaj yeem tsim qhov tseem ceeb ua ke, thaum koj nyem rau ntawm lub macro yuav pib. Thawj qhov tseem ceeb yuav tsum yog Ctrl, thiab tus neeg siv thib ob nruab koj tus kheej. Peb tau tsim lub M. qhov tseem ceeb ua piv txwv.
4. Tom ntej no, koj yuav tsum txiav txim siab qhov twg macro yuav khaws cia. Los ntawm lub neej ntawd, nws nyob hauv tib phau ntawv (cov ntaub ntawv), tab sis yog tias koj xav tau, koj tuaj yeem teeb tsa cia hauv phau ntawv tshiab lossis hauv phau ntawv cais ntawm macros. Peb yuav tawm ntawm tus nqi uas tsis muaj nqi.
5. Hauv cov teb qis tshaj plaws, koj tuaj yeem tso cov lus piav qhia haum heev, tab sis nws tsis tas yuav ua qhov no. Thaum txhua qhov chaw tau ua, nyem rau ntawm "OK" khawm.



6. Tom qab ntawd, tag nrho koj cov kev ua hauv phau ntawv no (cov ntaub ntawv) Excel yuav raug sau cia rau hauv macro kom txog thaum koj tus kheej nres cov ntaubntawv povthawj.
7. Piv txwv li, peb sau cov nyhuv yooj yim tshaj plaws: qhov sib ntxiv ntawm cov ntsiab lus ntawm peb lub hlwb (= C4 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + CF + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + C5 + CF).



8. Thaum lub algorithm tau tua, nyem rau ntawm "Nres Ntaub Ntawv" khawm. Lub pob no hloov los ntawm "macro decord" khawm tom qab nkag tau.

Tua tawm Macro

Txhawm rau xyuas seb yuav ua li cas cov ntaub ntawv kaw tseg ua haujlwm, ua ob peb yam yooj yim ua.

1. Nyem rau hauv tib lub block "code" Tuam ntawm Macros khawm lossis nyem qhov Alt + F8 tseem ceeb ua ke.



2. Tom qab ntawd, lub qhov rai qhib nrog cov npe ntawm cov ntawv sau ua ke. Peb tab tom nrhiav lub macro uas peb sau cia, faib nws thiab nyem rau ntawm "ROLD" khawm.



3. Koj tuaj yeem ua nws tau yooj yim dua thiab tsis txhob hu rau MACROS Xaiv qhov rai, txij thaum thawj theem uas peb teeb tsa qhov tseem ceeb ua ke hu rau lub macro. Hauv peb qhov teeb meem, qhov no yog Ctrl + M. Peb nyem qhov no sib xyaw ua ke ntawm cov keyboard, tom qab nws pib.
4. Raws li koj tau pom, nws ua tiav txhua qhov kev ua uas tau sau tseg ua ntej lawm.

Hloov kho macro

Lawm, yog tias koj xav tau, koj tuaj yeem hloov kho cov qauv tsim nws kom muaj kev tswj hwm nws thiab kho qee yam tsis raug thaum lub sijhawm sau cia.

1. Peb nyem rau ntawm "Macros" khawm dua. Nyob rau hauv lub qhov rais uas qhib, xaiv qhov xav tau thiab nyem rau ntawm "Kho kom raug" khawm.



2. Qhib "Microsoft Visually" (VBE) - Wednesday, uas lawv hloov tau tshwm sim.



3. Cov ntaubntawv ntawm txhua lub macro pib nrog cov sub txib, thiab xaus nrog qhov kawg sub hais kom ua. Tam sim ntawd tom qab sub, lub npe ntawm macro yog qhia. Cov neeg teb xov tooj ntau ("..."). Xaiv qhia txog kev xaiv ntawm tes. Piv txwv li, thaum cov "ntau (" C4 ") hais kom ua. Xaiv" C4 tau xaiv. Tus neeg teb xov tooj achescell.formulation1c1 yog siv los sau cov kev txiav txim hauv cov qauv thiab lwm yam kev suav.
4. Cia peb sim hloov me ntsis macro los ntawm kev ntxiv cov lus qhia:

   Ntau ("C3"). Xaiv

   Uantecellell.formular1c1 = "11"

5. Qhia tawm antecell.formation1c1 = "= r [-3] c + r [-2] c" = r [-4] c + r [-3] C + R [--2] C + R [--1] C. "



6. Kaw cov editor thiab tso tawm macro. Raws li koj tuaj yeem pom, vim peb hloov pauv, ib lub xov tooj ntxiv tau ntxiv rau cov ntaub ntawv. Nws kuj muaj nyob rau hauv kev suav ntawm tag nrho cov nyiaj.
7. Yog tias macro loj dhau, nws txoj kev ua tiav yuav siv sijhawm ntau, tab sis los ntawm kev hloov pauv ntawm tus lej peb tuaj yeem ceev cov txheej txheem. Ntxiv cov ntawv thov.Screenupdating = kev hais tsis tseeb. Nws yuav txuag tau xam lub zog, thiab yog li ua haujlwm kom ceev nrawm. Qhov no yog tiav los ntawm kev hloov kho qhov screen thaum lub laij teb. Txhawm rau rov hloov kho tshiab tom qab Macro tua, peb sau cov ntawv thov.Screenupdating = tseeb hais kom ua tiav thaum nws kawg.
8. Peb tseem ntxiv daim ntawv thov. Daim ntawv thov.Cov kab ntawv = XLCalCulation to thaum pib ntawm cov cai, thiab ntxiv applications.calculation = xlcalculationautomatic mus rau nws kawg. Los ntawm qhov no, peb xub tua lub zog tsis siv neeg rov qab los tom qab txhua qhov hloov ntawm cov hlwb, thiab qhov kawg ntawm lub macro - tig mus. Yog li, Excel xam cov txiaj ntsig tsuas yog ib zaug, thiab nws yuav tsis nco ntsoov ua tas li nws dua li lub sijhawm txuag.



Qhov Xaiv 2: Sau ib qho macro code los ntawm kos

Cov neeg siv tau ua tsis tau tsuas yog ua kom kho thiab ua kom zoo kaw cov macros, tab sis kuj sau lawv cov cai los ntawm xoom.

1. Txhawm rau mus rau qhov no, koj yuav tsum nyem rau ntawm "khawm kev pom", uas yog nyob ntawm qhov pib ntawm kev tsim tawm cov kab xev.



2. Lub VBE Editor Qhov rai yuav qhib, uas tau ua kom pom nyob rau hauv cov version yav dhau los.



3. Cov programmer teb muaj macros manually.

Raws li koj tuaj yeem pom, macros hauv Microsoft Excel tuaj yeem yooj yim ua haujlwm ntawm cov txheej txheem niaj hnub thiab monotonous txheej txheem. Txawm li cas los xij, muaj ntau yam, macros yog qhov tsim nyog rau qhov no, cov cai uas tau sau manually, thiab tsis cia sau cov yeeb yam. Ib qho ntxiv, nws cov cai tuaj yeem tsim kho kom zoo tshaj plaws ntawm VBE editor kom nrawm dua cov haujlwm tiav.