pull down menus in spread sheet

[Julies?s]

I was able to make the box that i wanted the pull down menu to go into by
making sure "show developer" tab is selected.>clicked developer
tab>controls>insert combo box from the active x controls>right clicked the
drop down and select properties,>highlighted my list in the list fill range.
And nothing happened.

I can make a drop down without the box by going to data>click data
validation>under all clicked list>under source highlighted my list>hit ok and
all is good.

Can't figure out how to combine the 2 things. Help!

 

[GSnyder]

To use the combo box, it takes a little more work, but not much. In the
format control box, you put your input range in (which it sounds like you
successfully did) and then place a cell link location into the Cell link box.
The cell link will contain the result of the user's interaction with the
box. If, for example, they choose the 4th item in the list, the number 4
will appear in your cell link. So if you chose $z$1 as your link, Z1 would
now have a 4 in it. This is the number you'll need to continue with your
formulas, code, or whatever.

After you're done modifying the box, click the Design Mode icon to turn
design mode back off again. My guess is that's the part you missed.