2 hyperlinks in 1 cell

the_cheat

New Member
Joined
Jan 12, 2005
Messages
32
I was asked if you could display 2 hyperlinks in 1 cell. My gut feeling tells me no but I figured I would ask the experts.
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

lenze

Legend
Joined
Feb 18, 2002
Messages
13,690
Interesting idea. Probably not. But, you could use an Event (Say Before_Doubleclick) to call up an option screen or Userform for two links. Would have to think about how that would work.

lenze
 

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,984
I think the short answer is "no".

Or rather, you can *display* two just fine =HYPERLINK("mailto: address@somewhere.com")&REPT(" ",5)&HYPERLINK("mailto: anotheraddress@somewhereelse.com")...you just can't have the implied functionality, as clicking anywhere on the cell will fire both.

You'd need to use a workaround, such as the Userform suggestion lenze suggests above.
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hi,

it would be interesting to know why they asked this
this would open the door to find an alternative

kind regards,
Erik

EDIT: are there not enough cells ? :LOL:
 

the_cheat

New Member
Joined
Jan 12, 2005
Messages
32

ADVERTISEMENT

Where can I find an example of an Event?? I'm unfamiliar with them.
 

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,026
No, not natively. While I am sure one can cobble up a solution using VBA code, the important question is "Why?" Is there a reason whoever asked you is trying to save using another cell? It's hard to believe they are running short of cells given that a *single* worksheet can contain 65,536*256 of them.

I was asked if you could display 2 hyperlinks in 1 cell. My gut feeling tells me no but I figured I would ask the experts.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,053
Messages
5,545,740
Members
410,703
Latest member
yaronjoseph
Top