Thaum ua haujlwm hauv Microsoft Excel hauv cov ntxhuav nrog cov ntaub ntawv theej tawm, nws yooj yim heev rau siv daim ntawv teev cia. Nrog nws, koj tuaj yeem xaiv qhov tsis xav tau los ntawm cov ntawv qhia zaub mov tsim tawm. Cia peb kawm seb yuav ua li cas thiaj li ua daim ntawv teev npe cia nyob rau hauv ntau txoj kev.
Tsim ib daim ntawv teev npe ntxiv
Qhov yooj yim tshaj plaws thiab tib lub sijhawm txoj kev ua haujlwm zoo tshaj plaws los tsim daim ntawv teev npe yog ib txoj kev raws li kev tsim cov ntawv teev npe sib cais.
Ua ntej tshaj plaws, peb ua lub rooj muag khoom noj khoom haus uas peb yuav siv cov ntawv qhia nyob rau hauv nco, thiab tseem sau cov npe ntawm cov ntaub ntawv uas peb yuav suav nrog hauv cov ntawv qhia no yav tom ntej. Cov ntaub ntawv no tuaj yeem muab tso rau ob qho tib si ntawm daim ntawv ntawm daim ntawv, thiab ntawm lwm tus, yog tias koj tsis xav tau ob lub rooj ua kom pom nyob ua ke.
Xaiv cov ntaub ntawv uas peb npaj yuav ntxiv rau daim ntawv nco-down. Peb txoj cai nyem, thiab hauv cov ntawv qhia zaub mov xaiv cov khoom "Teem npe ...".
Daim foos rau kev tsim lub npe qhib. Hauv "Npe" sau, sau lub npe yooj yim uas peb yuav paub txog cov npe no. Tab sis, lub npe no yuav tsum pib nrog ib tsab ntawv. Koj tuaj yeem sau cov lus ceeb toom, tab sis qhov no tsis tas. Nyem rau khawm "OK".
Mus rau "Cov ntaub ntawv" tab ntawm Microsoft Excel. Xaiv cov kab ntawv qhov chaw uas peb yuav tau siv hauv daim ntawv nco-down. Nyem rau ntawm "Cov ntaub ntawv pov thawj" khawm nyob ntawm Ribbon.
Lub qhov rai kev kuaj xyuas cov tswv yim tseem ceeb yuav qhib. Hauv kab "Parameters", hauv "Cov hom ntaub ntawv" teb, xaiv cov "Sau" ntsuas. Hauv thaj chaw "Tau", tso ib qho kev kos npe sib npaug, thiab tam sim ntawd uas tsis muaj chaw sau lub npe ntawm cov npe uas tau muab rau nws saum toj no. Nyem rau khawm "OK".
Daim ntawv teev cia hauv qab no npaj txhij. Tam sim no, thaum koj nyem rau ntawm lub pob, cov npe ntawm cov tsis yuav tshwm nyob rau hauv txhua lub cell ntawm cov kab kev cai tswjhwm, ntawm cov uas koj tuaj yeem xaiv ib qho twg los ntxiv rau lub cell.
Tsim cov lus teev cia siv cov cuab yeej tsim tawm
Qhov txheej txheem thib ob yuav tsim ib daim ntawv teev cia siv cov cuab yeej tsim tawm, uas yog siv ActiveX. Los ntawm lub neej ntawd, tsis muaj cov cuab yeej tsim tawm ntawm lub zog, yog li peb yuav xav ua kom thawj dua. Txhawm rau ua qhov no, mus rau "Chaw" Ntawv "Excel", thiab tom qab ntawd nyem rau ntawm kab ntawv "Xaiv".
Hauv lub qhov rai uas qhib, mus rau "Customize Ribbon" ntu, thiab muab lub cim tso rau ntawm "Tsim". Nyem rau khawm "OK".
Tom qab ntawd, ib lub tab tshwm ntawm cov xov uas muaj lub npe "Tus tsim tawm", uas peb tsiv mus. Peb kos npe hauv Microsoft Excel cov npe uas yuav tsum los ua daim ntawv teev zaub mov nqis. Tom qab ntawv, nyem rau ntawm "Insert" icon ntawm Ribbon, thiab ntawm cov khoom uas tshwm sim hauv "ActiveX Element" pawg, xaiv "Combo Box".
Peb nyem rau ntawm qhov chaw ntawm lub cell nrog sau yuav tsum. Raws li koj tuaj yeem pom, daim ntawv teev npe tau tshwm sim.
Tom qab ntawd peb hloov mus rau "Tsim Qauv". Nyem rau ntawm "Control Properties" khawm.
Lub zog tswj qhov rais qhib. Hauv kem "ListFillRange" ua ke los ntawm cov nyuv, peb hais kom meej thaj tsam ntawm lub hlwb ntawm lub rooj, cov ntaub ntawv ntawm cov uas yuav tsim cov khoom hauv daim ntawv teev xa khoom.
Tom ntej no, peb nyem rau ntawm lub xov tooj ntawm tes, thiab hauv cov ntawv qhia zaub mov peb mus los ntawm cov khoom "ComboBox Object" thiab "Hloov".
Daim ntawv teev cia nyob hauv Microsoft Excel tau npaj lawm.
Txhawm rau ua lwm lub hlwb uas muaj qhov tso cia hauv qab, cia li sawv ntawm txoj kab hauv qab ntawm tus xovtooj tiav lawm, nyem lub pob nyem, thiab rub nws cia.
Lwm Cov Ntawv
Tsis tas li, hauv Excel, koj tuaj yeem tsim cov teev npe nqes cia. Cov no yog cov npe zoo li no thaum, thaum xaiv ib tus nqi los ntawm daim ntawv teev npe, nws raug xaiv los xaiv cov tsis sib haum hauv lwm kab ntawv. Piv txwv li, thaum xaiv cov qos yaj ywm los ntawm daim ntawv teev npe, nws tau hais kom xaiv roj thiab grams raws li ntsuas, thiab thaum xaiv cov roj zaub - liv thiab milliliters.
Ua ntej tshaj plaws, peb yuav npaj lub rooj uas qhov chaw sau cia yuav nyob, thiab cais ua cov npe nrog cov npe ntawm cov khoom thiab ntsuas.
Peb tso ib lub npe rau txhua qhov ntawm cov npe, raws li peb twb tau ua nrog hauv qab uas muaj qhov ntawv tso cia.
Hauv thawj lub xovtooj, tsim cov npe raws nraim tib txoj kev ib yam li peb tau ua dhau los, los ntawm kev txheeb xyuas cov ntaub ntawv.
Hauv lub xovtooj thib ob, peb kuj tso lub qhov rai txheeb xyuas cov ntaub ntawv, tab sis hauv kem "Tau Qhov Twg Los" peb nkag mus rau qhov ua haujlwm "= INDIRECT" thiab qhov chaw nyob ntawm thawj lub cell. Piv txwv li, = INDIRECT ($ B3).
Raws li koj tuaj yeem pom, daim kab npe yog tsim.
Tam sim no, kom lub hlwb qis tau txais cov khoom zoo ib yam li lub sijhawm dhau los, xaiv cov kab ntawv sab saud, thiab thaum lub pob nyem nas, "luag".
Txhua yam, qhov rooj yog tsim.
Peb xam tawm yuav ua li cas thiaj li ua kom daim ntawv teev npe cia hauv Excel. Hauv qhov program, koj tuaj yeem tsim ob qho yooj yim daim ntawv teev npe thiab cov uas tos. Hauv qhov no, koj tuaj yeem siv ntau txoj kev tsim qauv. Cov kev xaiv yog nyob ntawm lub hom phiaj tshwj xeeb ntawm daim ntawv, lub hom phiaj ntawm nws cov kev tsim, thaj tsam, thiab lwm yam.
