Excel Pulldown Box

[msulazy]

Hello all. I want to insert a pulldown box in excel, but honestly don't know how. Theoretically, I'll have a column of numbers (say in grams), and next to it I'll have a pulldown box. Whatever the user selects (be it lbs, gals, liters, etc), I'll have it run an if/then type formula to convert the numbers of my original column and spit them out in the column next door. Like I said, theoretically. I think I can get around the formula once I figure out how to insert the box.

Can anyone shed any useful info on this or possibly a good weblink with useable information on the subject?

I've searched googled for the basics, scrolled through microsoft's worthless excel homepage, and figured I'd stop by here before I got the attitude check over at experts-exchange.

Thanks in advance.

 

[GilletteCat]

Tools -> Customize -> check the box for Control Toolbox

Once you add the Control toolbox to your set of menus, you'll have a drag-n-grop ability just like in Visual Basic, which, by the way, you have to know to do anything with the list box once you have incerted it into your spreadsheet. But I hope you knew it already...

 

[msulazy]

I had a feeling that was goign to be true, but mainly I was just looking for the way to get the box in there...(wasn't thinking toolbar). The rest I can work through. Thanks for the tip.