Combobox Setup Help

B

bkey01

I am trying to use a combobox and I am struggling. Can someone provid
me with an example of how to set one up?

I have an Excel workbook containing of 25 worksheets which each have a
least 7 different geographical reports. I want the end user to selec
a choice from the drop down list and the report be displayed.

Can someone please provide any help?

Thanks
 
E

Earl Kiosterud

Bkey,

A combo box puts a value into a cell. It sounds as if you instead need a
list of hyperlinks that link to the various reports. Try Insert -
Hyperlink.
 
P

Polly

I know how to set the combo box, but as for getting excel to display
report based on the choice selected, I'm not so sure... probably int
the VBA realm.

Create a list from say, cell A1:A10 with the different options you wan
available.
Open the 'forms' toolbar, and click the 'combo box' button.
Click somewhere on the sheet to set it down (you can move it later).
Press and hold 'ctrl', then click on the box.
Go 'Format - Control'
On the control tab, enter cells A1:A10 as the input range, and in cel
link, put the name of the cell you want the result stored in (fo
example, if you had 'London' as your second choice down, choosing tha
would put a '2' in the cell link)
That's it!
If you need to lock your sheet, you'll need to unlock all the cell
that relate to the combo box, as well as the box itself.
I hope this has helped a little..
 
Top