Dropdown list muchitokisi

Video

 Ndiani ane nguva shoma uye anoda kukurumidza kubata hunhu - tarisa vhidhiyo yekudzidzisa:

Ndivanaani vanofarira ruzivo uye nuances dzenzira dzese dzakatsanangurwa - kuwedzera pasi chinyorwa.

Nzira 1. Primitive

Kamwechete-kurudyi-tinya pane isina chinhu sero pasi pekoramu ine data, mamiriro emenyu yekuraira Sarudza kubva kudonhodzo pasi (Sarudza kubva pakudonhedza pasi) kana kudzvanya nzira yekudimbudzira kiibhodhi ALT+pasi museve. Iyo nzira haishande kana kamwechete mutsara usina chinhu uchiparadzanisa sero uye data column, kana kana iwe uchida chigadzirwa chisina kumboiswa pamusoro:

Nzira 2. Standard

1. Sarudza maseru ane data iyo inofanirwa kuiswa mune yekudonha-pasi runyorwa (semuenzaniso, mazita ezvigadzirwa).
2. Kana iwe uine Excel 2003 kana kupfuura, sarudza kubva pane menyu Pinza – Zita – Govera (Isa - Zita - Define), kana Excel 2007 kana nyowani, vhura iyo tab Formulas uye shandisa bhatani Zita reManejaZvadaro sika. Isa zita (chero zita rinogoneka, asi pasina nzvimbo uye tanga nebhii!) yemhando yakasarudzwa (semuenzaniso. chigadzirwa) Dzvanya pa OK.
3. Sarudza maseru (iwe unogona kuve akati wandei kamwechete) mauri kuda kuwana yekudonha-pasi rondedzero uye sarudza kubva kumenyu (pane tab) Dhata - Tarisa (Data - Kusimbiswa). Kubva kudonhodzo pasi Rudzi rweData (Bvumira) sarudza sarudzo List uye pinda mumutsara mabviro yakaenzana nechiratidzo uye zita remhando (kureva =Zvigadzirwa).

dzvanya OK.

Zvose! Enjoy!

Chinhu chakakosha nuance. A dynamic name range, senge price list, inogonawo kushanda sedata source ye list. Zvino, kana uchiwedzera zvigadzirwa pamitengo yemitengo, ivo vanozongowedzerwa kune yekudonha-pasi rondedzero. Imwe hunyengeri hunowanzo shandiswa kune akadaro rondedzero kugadzira akabatana anodonhedza (apo izvo zviri mune imwe runyorwa zvinoshanduka zvichienderana nekusarudzwa mune imwe).

Nzira 3: Kudzora

Iyi nzira ndeyekuisa chinhu chitsva papepa - combo box control, uye wozoisunga kune mitsara papepa. Nokuda kweizvi:

1. MuExcel 2007/2010, vhura iyo tab Developer. Mune shanduro dzekare, toolbar Forms kuburikidza nemenyu Tarisa - Maturusi - Mafomu (Tarisa - Maturusi - Mafomu). Kana iyi tebhu isingaonekwe, tinya bhatani Hofisi - Excel Sarudzo - Checkbox Ratidza Developer Tab muRibhoni (Bhatani reHofisi - Excel Sarudzo - Ratidza Tabhu yeMugadziri muRibhoni)
2. Tarisa iyo yekudonha icon pakati pemafomu ekudzora (kwete ActiveX!). Tevera mazano e-pop-up combo box:

   Dzvanya pachiratidzo uye dhirowa diki rectangle yakatwasuka - runyorwa rweramangwana.

3. Tinya kurudyi pane yakadhirowa rondedzero uye sarudza kuraira Object Format (Format control). Mubhokisi rebhokisi rinoonekwa, gadzira

• Gadzira runyoro nemhando - sarudza masero ane mazita ezvigadzirwa zvinofanira kuiswa mumutsara
• Kutaurirana kwesero - tsanangura sero kwaunoda kuratidza nhamba yeserial yechinhu chakasarudzwa nemushandisi.
• Nhamba yemitsara yemazita - mangani mitsara yekuratidzira mune yekudonha rondedzero. Iyo yakasarudzika ndeye 8, asi yakawanda inogoneka, iyo yapfuura nzira isingabvumire.

Mushure mekunge mavharidza OK list inogona kushandiswa.

Kuti uratidze zita rayo pachinzvimbo cheiyo serial nhamba yechinhu, iwe unogona kuwedzera kushandisa basa INDEX (INDEX), iyo inogona kuratidza zviri mukati mesero inodiwa kubva mumhando:

Nzira 4: ActiveX kutonga

Iyi nzira inofanana neyakapfuura. Musiyano mukuru ndewekuti haisi kutonga kunowedzerwa kune pepa, asi ActiveX control. "Combo Box" kubva mubhokisi rekudonhedza pasi pebhatani Insert kubva kune tab Developer:

Nzira yekuwedzera yakafanana - sarudza chinhu kubva pane chinyorwa uye chidhirowe papepa. Asi ipapo misiyano yakakomba kubva panzira yapfuura inotanga.

Chekutanga, iyo yakagadzirwa ActiveX yekudonhedza-pasi rondedzero inogona kunge iri mumatunhu maviri akasiyana - debug modhi, kana iwe uchinge wagadzirisa maparamita ayo uye zvivakwa, fambisa ichitenderedza pepa uye udzore saizi, uye - yekuisa maitiro, kana chinhu chega chaunogona kuita. sarudza data kubva pairi. Kuchinja pakati pemamodhi aya kunoitwa uchishandisa bhatani. Design Mode Tab Developer:

Kana bhatani iri rikadzvanywa, saka tinogona kugadzirisa maparamendi eiyo yekudonha-pasi runyoro nekudzvanya bhatani riri padyo. Properties, iyo inovhura hwindo rine runyoro rwese anogona kurongwa echinhu chakasarudzwa:

Izvo zvakanyanya kudikanwa uye zvinobatsira zvivakwa zvinogona uye zvinofanirwa kugadzirwa:

• ListFillRange - huwandu hwemasero uko iyo data yerondedzero inotorwa kubva. Izvo hazvikubvumidze iwe kuti usarudze renji negonzo, iwe unongoda kuipinda nemaoko ako kubva pane keyboard (semuenzaniso, Sheet2! A1: A5)
• LinkedCell - iyo sero yakabatana uko chinhu chakasarudzwa kubva pane rondedzero chicharatidzwa
• ListRows - nhamba yemitsara yakaratidzwa
• Font - font, saizi, chimiro (italic, underline, etc. kunze kweruvara)
• ForeColor и backcolor - mavara uye kumashure kwemavara, zvichiteerana

Iyo yakakura uye ine mafuta kuwedzera yeiyi nzira kugona kukurumidza kusvetukira kune yaunoda chinhu mune runyorwa paunopinda mabhii ekutanga kubva kukhibhodi (!), iyo isingawanikwe kune dzimwe nzira dzese. Pfungwa yakanaka, zvakare, kugona kugadzirisa iyo yekuona mharidzo (mavara, mafonti, nezvimwewo)

Paunenge uchishandisa nzira iyi, zvinokwanisikawo kutsanangura se ListFillRange kwete chete-dimensional mitsara. Iwe unogona, semuenzaniso, kuseta huwandu hwemakoramu maviri nemitsara yakati wandei, zvichiratidza zvakare kuti iwe unofanirwa kuratidza makoramu maviri (pfuma. ColumnCount=2). Ipapo iwe unogona kuwana mhedzisiro inoyevedza inobhadhara iyo yese kuedza kwakashandiswa pane mamwe marongero:

Tafura yekupedzisira yekuenzanisa yenzira dzese

:

• Dropdown list ine data kubva kune imwe faira
• Kugadzira Dependent Dropdowns
• Kugadzira otomatiki kwezvinyorwa zvekudonhedza nePLEX yekuwedzera
• Kusarudza mufananidzo kubva pane yekudonha rondedzero
• Kubvisa otomatiki kwezvinhu zvakatoshandiswa kubva pane yekudonhedza pasi
• Dropdown list ine otomatiki kuwedzera kwezvinhu zvitsva