Forum Discussion
john_kelly105
Aug 30, 2022Copper Contributor
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 ...
NikolinoDE
Aug 31, 2022Platinum Contributor
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)
john_kelly105
Aug 31, 2022Copper Contributor
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
- NikolinoDESep 01, 2022Platinum Contributor
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.
- john_kelly105Sep 01, 2022Copper ContributorThank yo so much for your help, Yes this looks good and works for me. Kindest regards John