Links in a drop down menu

  • Thread starter Thread starter saybut
  • Start date Start date
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
 
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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying a Drop Down Menu 2
How do I use different colours in drop down menus in Excel 2003? 4
Drop-down menu and additional sheets 4
drop down menu color 1
Drop Down Menu 4
Excel Drop Down Menu linked? 6
Linking choices in drop down menu to have automatic answer... 3
How to get the full list of drop down menu 1

Back
Top