Excel Drop Down List

[AJ]

I am currently working on a project requiring the use of a drop down
list. I am able to create the list and link it to it's data source
just fine. However I am not sure how to get the selected choice to
fill in the appropriate cell in the worksheet?

Sincerely,

An Excel Dummy in need of help!!!

 

[IC]

I assume you mean a combobox, in which case there is a property in the
properties list called Linked Cell. The contents of the combobox are
reflected in the cell you add here.

Ian

 

[Dave Peterson]

IC gave you the answer for the combobox from the control toolbox toolbar.

But you may want to look at Data|validation. It has faults, but it's pretty
easy to work with:
Debra Dalgleish has some tips for Data|validation at:
http://www.contextures.com/xlDataVal01.html



And if you're using a dropdown from the Forms toolbar, rightclick on it and
choose format control.

From there, choose the control tab
there's a cell link box you can use.


Then use a helper cell to get the value:
say A1:A10 held the input range.
And B1 held the cell link.
Put this in C1:
=if(b1="","",index(a1:a10,b1))