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.
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

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
8,015
Office Version
  1. 365
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,029
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.
 

Forum statistics

Threads
1,140,916
Messages
5,703,161
Members
421,278
Latest member
16cwilliams

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top