Combo Box

[Emile Zac]

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

 

[mangesh_yadav]

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

 

[Dave Peterson]

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