links and drop down menus

Copper Contributor

I am trying to use a dropdown menu using a sourced list, some of the cells in the list are links to other information, however when i use the drop down menu in another spreadsheet the item chosen is not linked. is it possible to maintain the link when it is chosen?

4 Replies


Here is a file with an example of how to include hyperlinks in the dropdown menu.


Hope I could help you with these information.



I know I don't know anything (Socrates)



Hi thanks for your reply, I have attached a file, your information does not seem to work for me maybe because only some of the cells are linked. Let me know.


Kindest regards




Your list contains VBA code, at the same time I don't know what names are entered in the manager. Anyway, here is a simple variant that works. Would have to try to transfer it to your worksheet.

Thank yo so much for your help, Yes this looks good and works for me. Kindest regards John