Cov khoom uas tau muab tso rau ntawm daim ntawv ua haujlwm hauv Excel phau ntawv ua haujlwm thiab siv nkag rau, tso saib, thiab suav cov ntaub ntawv hu ua kev tswj hwm. Muaj ob yam kev tswj hauv Microsoft Office Excel: ActiveX tswj thiab daim ntawv tswj. Lawv zoo sib xws hauv kev pom thiab kev ua haujlwm, txawm hais tias muaj qee qhov sib txawv ntawm lawv. Muaj ob peb qeb ua los mus tsim lub pob hauv Excel.
Cov Lus Qhia
Kauj ruam 1
Pib Microsoft Office Excel thiab ua kom paub tseeb Tus tsim tab los pab koj. Txhawm rau ua li no, nyem lub Chaw Haujlwm Hauv Tshab nyob rau sab laug sab laug ntawm lub qhov rais thiab xaiv Excel Xaiv los ntawm cov ntawv qhia zaub mov. Nyem rau ntawm General tab thiab nrhiav ntu Basic Excel Options. Khij lub thawv "Show Developer tab on Ribbon" nrog tus cim sau npe thiab siv cov kev teeb tsa tshiab.
Kauj ruam 2
Txhawm rau tso kev tswj hwm rau ntawm daim ntawv ua haujlwm, nyem rau ntawm "Tus tsim tawm" tab ntawm "Ntxig" khawm hauv khawm "Tswj". Cov submenu nthuav dav. Xaiv cov kev tswj hwm tsim nyog los ntawm "Cov Kev Tswj Cov Txheej Txheem" lossis "ActiveX Tswj". Lub ntaj hloov pauv mus rau tus ntoo khaub lig.
Kauj ruam 3
Nyem nrog khawm sab laug hauv qhov chaw uas xaiv cov khoom yuav tsum muab tso rau. Thaum lub pob tshwm ntawm daim ntawv, koj tuaj yeem txav nws dawb, hloov nws qhov loj me, tau xaiv nws yav dhau los nrog sab laug nas khawm.
Kauj ruam 4
Thaum koj ntxiv cov nyees khawm rau ib qho ntawv ua haujlwm, lawv tau muab cov npe tsis raug. Txhawm rau pauv tau ib lub pob los ntawm "Cov kab ke tswj hwm" ntu, xaiv nws thiab nyem ob npaug rau nws nrog nas khawm laug. Lub npe qub yuav ua kom pom tseeb, koj tuaj yeem rho tawm nws thiab muab khawm nrog koj lub npe.
Kauj ruam 5
Txhawm rau pauv lub pob nyem los ntawm ntu "ActiveX tswj", nyem sab xis rau nws thiab xaiv "Khoom …" los ntawm cov ntawv qhia zaub mov nco (piv txwv li, "CommandButton Object") thiab Kho kom raug sub-yam, khawm lub npe yuav dhau los muaj rau kho.
Kauj Ruam 6
Rau kev ua haujlwm ntxiv nrog lub pob ntawm daim ntawv tswj hwm, xaiv lub pob uas xav tau ntawm daim ntawv thiab nyem rau ntawm "Tus tsim tawm" tab lub pob "Cov Khoom" hauv seem "Tswj". Qhov no yuav qhib lub npov Tshiab ntawm lub thawv uas koj tuaj yeem tsim txhua qhov tsis xav tau. Txhawm rau ua haujlwm nrog ActiveX tswj hwm, muab ob npaug rau nyem rau ntawm lub pob lossis nias lub Code View button hauv "Cov ຄວບ ຄຸມ" ntawm "Tsim tawm" tab kom qhib Microsoft Visual Basic qhov rai nrog txhua yam tsim nyog thiab cov kev xaiv.
