Thaum ua hauj lwm hauv Microsoft Excel hauv cov ntxhuav nrog cov ntaub ntawv sib luag, nws yooj yim heev rau siv daim ntawv teev npe cia. Nrog nws, koj tuaj yeem xaiv qhov kev xaiv ntawm cov zaub mov tawm. Cia peb mam li paub tias yuav ua li cas thiaj ua tau ib daim ntawv teev npe ntau dua.
Tsim ib qho ntawv ntxiv
Qhov yoojyim tshaj plaws, thiab tib lub sij hawm qhov kev ua haujlwm zoo tshaj plaws los tsim ib daim ntawv teev npe cia, yog ib txoj hauv kev los tsim ib daim ntawv teev npe ntawm cov ntaub ntawv.
Ua ntej tshaj plaws, peb ua ib lub rooj-dawb paug, uas peb yuav siv cov ntawv qhia zaub mov nram qab no, thiab kuj sau ib daim ntawv teev npe ntawm cov ntaub ntawv uas yuav muab tso rau hauv cov ntawv qhia no yav tom ntej. Cov ntaub ntawv no tuaj yeem tso tau ob qho tib si rau tib daim ntawv ntawm daim ntawv, thiab ntawm lwm qhov, yog tias koj tsis xav kom ob leeg xam pom ob sab ua ke.
Xaiv cov ntaub ntawv uas peb npaj yuav ntxiv rau ntawm daim ntawv teev npe cia. Nias lub pob nyem khawm, thiab hauv cov ntawv qhia zaub mov lub ntsiab lus xaiv cov khoom "Assign a name ...".
Lub npe tsim daim ntawv qhib. Nyob hauv thaj chaw "Npe" nkag mus rau txhua lub npe yooj yim uas peb yuav pom txog daim ntawv teev npe no. Tab sis, lub npe no yuav tsum pib nrog ib tsab ntawv. Koj tuaj yeem sau tau ib daim ntawv, tab sis qhov no tsis tsim nyog. Nias rau ntawm "OK" khawm.
Mus rau "Cov Ntaub Ntawv" tab ntawm Microsoft Excel. Xaiv lub rooj ntawm qhov chaw uas peb tab tom yuav thov tau cov npe ntawm qhov sau tseg. Nias ntawm qhov "Data Verification" khawm nyob rau ntawm Ribbon.
Lub thawv input qhov rai qhib opens. Hauv qhov "Parameters" tab nyob hauv "Hom Type", xaiv "Sau" parameter. Nyob rau hauv "Qhov Chaw" ntawm "peb tau" kos npe, thiab tam sim ntawd tsis muaj chaw peb sau lub npe ntawm daim ntawv teev npe, uas peb tau muab rau nws saum toj no. Nias rau ntawm "OK" khawm.
Daim ntawv tso npe cia yog npaj txhij. Tam sim no, thaum koj nias rau khawm, txhua lub xovtooj ntawm qhov tau teev tseg yuav tso tawm ib daim ntawv teev cov tsis muaj, qhov uas koj tuaj yeem xaiv ib qho ntxiv rau ntawm tes.
Tsim ib daim ntawv teev npe cia uas siv cov cuab yeej tsim tawm
Qhov thib ob txoj kev yuav tsim ib daim ntawv teev npe cia siv cov cuab yeej tsim tawm, uas yog siv ActiveX. Yog vim li cas, lub luag haujlwm ntawm cov cuab yeej tsim tawm tsis tuaj, yog li ntawd peb yuav xub xav pab lawv. Ua li no, mus rau "Cov Ntaub Ntawv" ntawm Excel, ces nias lub npe "Parameters".
Nyob rau hauv lub qhov rais qhib, mus rau qhov "Ribbon Settings" subsection, thiab khij lub voj voog ib sab ntawm tus nqi "Tsim tawm". Nias rau ntawm "OK" khawm.
Tom qab ntawd, lub npe hu ua "Developer" tshwm tuaj rau ntawm daim ntawv xov xwm, uas peb tsiv mus. Kos rau hauv Microsoft Excel sau, uas yuav tsum yog ib qho khoom noj khoom haus. Tom qab ntawd, nias qhov Ribbon ntawm "Insert" icon, thiab ntawm cov khoom uas tau tshwm sim hauv "ActiveX Element", xaiv "Combo Box".
Peb nias rau ntawm qhov chaw uas yuav tsum muaj lub xov tooj ntawm tes nrog cov npe. Raws li koj tau pom, daim ntawv teev npe tau tshwm sim.
Tom qab ntawd peb tsiv mus rau "Hom Tsim". Ndliv lub khawm "Control Properties".
Kev tswj cov khoom qhib qhov rai qhib. Nyob rau ntawm "ListFillRange" sab, manually, tom qab ib txoj hnyuv, teem ntau yam ntawm cov hlwb cov lus, cov ntaub ntawv ntawm cov ntaub ntawv yuav tsim cov khoom npe ntawm cov khoom npe.
Tom ntej, nyem rau ntawm tes, thiab hauv cov ntawv qhia zaub mov, mus rau cov khoom "ComboBox Object" thiab "Hloov".
Microsoft Excel nco-down daim ntawv yog npaj txhij.
Txhawm rau lwm lub hlwb nrog cov ntawv sau npe, cia li sawv ntsug ntawm sab xis ntawm lub xov tooj ntawm tes tiav, nias tus nas khawm, thiab rub nws.
Cov Ntawv Sib Tham
Tsis tas li ntawd, hauv Excel, koj tuaj yeem tsim cov npe sau xa rov qab. Cov no yog cov npe thaum, thaum xaiv ib tus nqi los ntawm ib daim ntawv teev, hauv lwm kem nws tau npaj siab xaiv cov kev tsis sib haum. Piv txwv li, thaum xaiv los ntawm daim ntawv teev cov khoom qoob loo, nws raug npaj siab xaiv cov kilograms thiab grams li ntsuas, thiab thaum xaiv zaub roj - liters thiab milliliters.
Ua ntej tshaj plaws, peb yuav npaj ib lub rooj rau cov npe ntawm cov ntawv sau npe, thiab cais ua npe nrog cov npe khoom thiab ntsuas kev ntsuas.
Peb muab ib lub npe teev rau txhua qhov ntawm cov npe, raws li peb tau ua ua ntej nrog cov ntawv sau npe sib xws li qub.
Hauv thawj lub cell, peb tsim ib daim ntawv teev npe raws nraim tib yam li peb tau ua ua ntej, los ntawm cov ntaub ntawv pov thawj.
Nyob rau hauv ob lub xov tooj ntawm tes, peb kuj tso tawm cov ntaub ntawv pov thawj ntawm cov ntaub ntawv, tab sis nyob rau ntawm "Qhov", peb nkag mus rau qhov kev ua haujlwm "= DSSB" thiab qhov chaw nyob ntawm thawj lub xovtooj. Piv txwv, = CEEV XWM ($ B3).
Raws li koj tau pom, daim ntawv yog tsim.
Tam sim no, nyob rau hauv kev txiav txim rau lub qis hlwb kom tau txais tib yam khoom qub raws li lub sij hawm dhau los, xaiv lub qaum hlwb, thiab nrog nas khawm nias, cab nws.
Txhua yam, lub rooj yog tsim.
Peb xav tias yuav ua li cas thiaj ua tau ib daim ntawv teev npe hauv Excel. Qhov kev zov me nyuam muaj peev xwm tsim tau ob qho tib si npe thiab cov neeg tseem ceeb. Hauv qhov no, koj tuaj yeem siv ntau txoj hau kev tsim. Qhov kev xaiv ntawd nyob ntawm lub hom phiaj ntawm daim ntawv teev npe, lub hom phiaj ntawm nws cov creation, qhov, thiab lwm yam.
