Links in a drop down menu

S

saybut

HI,

I was wondering if anyone could help?

In my spreadsheet I have several links to various places in the sheet
At the moment they are just hyperlinks, and so I can only have 1 lin
per cell.

I created a drop down menu to try and incorporate more links into eac
cell.

Is there any way to have the items in the drop down menu to work a
links to places in the spreadsheet?

Any help is greatly appreciated.

Thank you.

Mark
 
D

Dave Peterson

Depends on how you created the dropdowns--Data|validation, or a dropdown from
the Forms toolbar or a Combobox from the Control Toolbox toolbar.

And what version of excel (for the data|validation portion).

You could use code in the worksheet_change event (data|validation), or code in
an assigned macro (Forms dropdown) or code behind the combobox (control toolbox
toolbar).
 
Top