Tsis muaj teeb meem dab tsi daim ntawv thov los ntawm Microsoft Office pob koj ua haujlwm, muab nws Lo Lus, Excel lossis PowerPoint, koj zaum ua qee yam haujlwm ib txwm muaj. Ntxiv mus, koj ua lawv ntau zaus hauv ib hnub. Koj tuaj yeem, ntawm chav kawm, siv qhov "Hloov hais kom ua", txawm li cas los xij, yog tias koj yuav tsum tau rov ua dua peb lossis peb zaug kev ua, tom qab ntawd siv cov lus txib no ua teeb meem. Tus macro yuav pab koj.
Cov Lus Qhia
Kauj ruam 1
Nrog VBA, koj tuaj yeem ua tus macro uas muaj cov npe ntawm ntau cov yeeb yam uas koj xav tau kom nco ntsoov txhawm rau ua lawv dua ib qho zuj zus. Txhawm rau sau ntawv loj heev, yuav tsum muaj ntau kauj ruam.
Kauj ruam 2
Ua ntej, qhib thiab npaj daim ntawv thov uas koj xav kom sau cov ntawv loj loj. Tom qab ntawd mus rau cov ntawv qhia zaub mov los ntawm txoj saw Service-> Macro-> Pib sau cia. Tom ntej no, "Teev Macro" lub npov yuav tshwm rau ntawm qhov screen.
Kauj ruam 3
Los ntawm lub neej ntawd, lub Macro Lub npe teb qhia tus qauv lub npe Macro1 lossis ib yam dab tsi zoo li ntawd. Koj tuaj yeem hloov nws nrog qhov koj nyiam.
Kauj ruam 4
Hauv Microsoft Office, zoo li hauv Excel, koj tuaj yeem muab cov keyboard shortcut tshwj xeeb rau ib qho macro. Hauv Lo Lus, nyem rau lub pob cuab tam khawm kom txuas cov ntawv loj loj rau cov twj khawm. Koj tseem tuaj yeem nyem lub pob nyem khawm kom muab qhov ua haujlwm tseem ceeb los hu rau macro. Hauv Excel, hauv kab ntawv sau hu ua "Keyboard shortcut Ctrl +" koj yuav tsum sau ib tsab ntawv.
Kauj ruam 5
Nyob rau hauv cov ntawv thov xws li Excel, Lo Lus, lossis PowerPoint, koj muaj kev xaiv los siv qhov sau hauv-tseg cov npe kom qhia meej qhov twg koj macro yuav tau txais kev cawmdim. Sau cov lus piav qhia rau macro hauv qhov lus piav qhia. Tom qab ntawv ces nyem rau qhov Ok. Raws li qhov tshwm sim, koj yuav rov qab los rau hauv daim ntawv, thiab hauv kab xwm txheej koj yuav pom cov ntawv sau "Cov Ntawv Teev Tseg" (REC) thiab cov cuab yeej me "nres Cov Ntawv Teev Tseg" yuav tshwm, uas pom kwv yees li ntawm nruab nrab ntawm qhov screen. Nws cov npe kab qhia tsuas yog ib qho kev sau ntawv xwb - Os.
Kauj Ruam 6
Tom qab ntawd, ua tiav txhua qhov haujlwm uas yuav tsum tau muab sau cia rau hauv macro. Txij li cov ntawv sau yuav sau tag nrho koj cov kev ua (nrog rau tsuas yog tsis suav nyem rau ntawm lub Nres Cov Ntaub Ntawv Teev Tseg khawm), ceev faj kom tsis txhob ua qhov tsis tsim nyog ua lossis cov lus txib thaum sau macro. Tom qab sau tag nrho cov kev ua, mus rau cov ntawv qhia zaub mov los ntawm cov cuab yeej siv cov cuab yeej -> Macro-> Nres kaw, nyob ntawm qhov txheej txheem ntawm tib lub npe.
