Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Combo Box
Hello:
I have created a combo box that references a list in the spreadsheet and I can select an item in the list and a number is put in the "cell link" I thought this box had the capability of typing in text and somehow that text would be associated with a cell link I have read and searched but now need some direction as to how the typed text is handled in this type of box. Thank you in advance for any help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box
The problem can be directly solved if you use the combobox from th
"Control Toolbox" menu and not the "Forms" menu. Click on VIEW TOOLBARS. Check the CONTROL TOOLBOX item. This will display the contro toolbox from where you can select the combobox. This combo box wil directly put the text instead of the number in the desired cell. - Manges -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Combo Box
If you used a combobox from the control toolbox toolbar, then you can show that
toolbar. Then click on the "Design mode" icon rightclick on your combobox Look for LinkedCell and type in the address of the cell you want. (and don't forget to leave design mode.) === If you used a dropdown (aka combobox) from the Forms toolbar, you can rightclick on the dropdown choose Format Control|Control Tab and assign the cell link there. But this returns an index into the list. If you used a range for your input list, you could use this kind of thing: Say the input list is a1:a10, the cell link is B1. Then in C1: =if(b1=0,"",index(a1:a10,b1)) ==== As an aside, there's another thingy that looks a lot like a combobox. It's Data|Validation. You may find it much easier to work with. Debra Dalgleish has nice instructions starting at: http://www.contextures.com/xlDataVal01.html Emile Zac wrote: Hello: I have created a combo box that references a list in the spreadsheet and I can select an item in the list and a number is put in the "cell link" I thought this box had the capability of typing in text and somehow that text would be associated with a cell link I have read and searched but now need some direction as to how the typed text is handled in this type of box. Thank you in advance for any help -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking a form combo box... results from the combo box to another | Excel Discussion (Misc queries) | |||
combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
In Excel I need to set up a combo box based on another combo box. | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) |