Two hyperlinks in a cell in Excel - possible?

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?
LVL 1
agwalshAsked:
Who is Participating?
 
Peter HutchisonSenior Network Systems SpecialistCommented:
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
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

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

cheers, teylyn
0
 
agwalshAuthor Commented:
Thank you both for that. Giving you both equal points but awarding Peter Hutchison best solution simply because it's a possible workaround....
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
EirmanChief Operations ManagerCommented:
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
 
EirmanChief Operations ManagerCommented:
That was bad luck, the question closed while I was researching!
(and there also other solutions out there)
0
 
agwalshAuthor Commented:
@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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.