Excel Question

[Jeremy]

I am making a template list of Funds that our company
uses and I was wondering how I make a pull down menu to
choose from the different funds. So that I don't have to
keep tying all the names in.

Thanks for the help

 

[Bill Lunney]

Right click on a blank bit of the toolbar area and make sure the FORMS
toolbar is shown.

Click the 'combo box' icon

Draw the box on the worksheet roughly where you want it to appear

Right click the newly drawn combobox and choose Format Control

Set input range equal to the source for the list

Set cell link to the cell where you want the result

If this isn't particulary clear let me know and I'll make some easier to
follow instructions and post them to my site.


--

Regards,


Bill Lunney
www.billlunney.com