Solved

Two hyperlinks in a cell in Excel - possible?

Posted on 2014-11-15
6
201 Views
Last Modified: 2014-11-15
hi Folks
Got asked an odd question...the person wanted to know if it was possible to have two hyperlinks in the same cell. I was inclined to say No. But wanted to check first. I'm sure it can be done with some VBA wizardry but it's not that high a priority for the person. Is it possible?
0
Comment
Question by:agwalsh
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 19

Accepted Solution

by:
Peter Hutchison earned 250 total points
ID: 40444308
As a work around, you could add a hyperlink into the cell, then add a comment to that cell, and insert the 2nd hyperlink to that comment.
0
 
LVL 50

Assisted Solution

by:Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 250 total points
ID: 40444313
Hello,

your initial hunch is correct. You cannot create more than one hyperlink in a cell, not even with VBA.

cheers, teylyn
0
 

Author Closing Comment

by:agwalsh
ID: 40444320
Thank you both for that. Giving you both equal points but awarding Peter Hutchison best solution simply because it's a possible workaround....
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 23

Expert Comment

by:Eirman
ID: 40444321
I tries peter's suggestion above, but the comment hyperlink does not appear to be clickable

There is a method/workaround where you could use the OLE features of Excel to insert objects from programs
that support multiple hyperlinks.
http://excel.tips.net/T002805_Putting_More_than_One_Hyperlink_in_a_Cell.html

This clunky method uses a vlookup to make the cell dynamic and allow a choice of hyperlinks
http://www.mrexcel.com/forum/excel-questions/708705-single-cell-multiple-hyperlinks.html
0
 
LVL 23

Expert Comment

by:Eirman
ID: 40444323
That was bad luck, the question closed while I was researching!
(and there also other solutions out there)
0
 

Author Comment

by:agwalsh
ID: 40444425
@Eirman - this user just asked me in passing because he had come across it once before. I think the mrexcel solution would be the equivalent of a sledgehammer and a nut :-). He just wanted an easy way and while my feeling was that it wasn't possible I just wanted to check for him. But thanks for looking to research it anyway :-) appreciated.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question