How do i get an cell to read from a drop-down/combo box?

S

Sez

I have created a drop down list/box in excel. However, I am trying get a
cell on another worksheet to read whatever gets chosen in the drop down list
box. I have found a visual basic code for doing it using a list box, but
can't seem to get it to work using a drop-down box.

Any help would be gratefully appreciated.
 
P

PaulW

Can you not just put the cell reference, eg. ='Sheet 1'!A1 for it to copy
this information?
 
S

Sez

The drop down box does not sit in the cell - it sits on top - if I were to
use the ='Sheet1'!A1 cell reference - nothing would appears in the cell.
 
D

Dave Peterson

It depends on what a dropdown listbox is.

If you used a dropdown from the forms toolbar, you could use a linked cell to
return the index of the selected item.

Say you used A1:A10 as the Input range.
And you used B1 as the Linked cell.
You could put this in C1:
=if(b1="","",index(a1:a10,b1))

If you used a combobox from the Control toolbox toolbar, you could use the value
in that linked cell directly.

For the dropdown from the Forms toolbar, you can rightclick on it, choose Format
Control, then Control to get to the dialog for these settings.

For the combobox from the control toolbox toolbar, you have to go into design
mode (another icon on that same toolbar) and then rightclick and choose
properties to see them.
 
Top