Forum Discussion
links and drop down menus
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 ...
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
John
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