Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 51
Default 3 different hyperlinks attached to the same cell?

I need to attach 3 different hyperlinks to the same cell.
When I click on the cell I need to open 3 different web pages in the same
time.
Thanks a lot!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 320
Default 3 different hyperlinks attached to the same cell?

You can't do it with a regular hyperlink, but you can do it with VBA code,
something like this -- right-click the sheet tab, select View Code, put this
in (assumes the cell inquestion is F4):
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$F$4" Then
ThisWorkbook.FollowHyperlink "http://www.whatever.com",
NewWindow:=True
ThisWorkbook.FollowHyperlink "http://www.xyz.com", NewWindow:=True
ThisWorkbook.FollowHyperlink "http://www.abc.com", NewWindow:=True
End If
End Sub

"Dan Tabla" wrote:

I need to attach 3 different hyperlinks to the same cell.
When I click on the cell I need to open 3 different web pages in the same
time.
Thanks a lot!

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 51
Default 3 different hyperlinks attached to the same cell?

Bob, God bless you! It's working and very easy!
Compile succesfully!
"Bob Umlas, Excel MVP" wrote:

You can't do it with a regular hyperlink, but you can do it with VBA code,
something like this -- right-click the sheet tab, select View Code, put this
in (assumes the cell inquestion is F4):
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address = "$F$4" Then
ThisWorkbook.FollowHyperlink "http://www.whatever.com",
NewWindow:=True
ThisWorkbook.FollowHyperlink "http://www.xyz.com", NewWindow:=True
ThisWorkbook.FollowHyperlink "http://www.abc.com", NewWindow:=True
End If
End Sub

"Dan Tabla" wrote:

I need to attach 3 different hyperlinks to the same cell.
When I click on the cell I need to open 3 different web pages in the same
time.
Thanks a lot!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to populate cell based on drop-down list attached to the SAME cell? lpteague Excel Discussion (Misc queries) 1 October 4th 10 08:23 AM
How to keep linked cell attached to it's source cell? Dyefrog Excel Discussion (Misc queries) 2 May 1st 08 06:48 PM
Graph attached into cell Marce Excel Worksheet Functions 1 March 21st 08 10:03 PM
Need to get cell input message be attached to cell R Excel Discussion (Misc queries) 3 December 21st 07 03:50 PM
Timestamping a cell with a Link already attached to it. [email protected] Excel Worksheet Functions 0 October 18th 06 09:36 PM


All times are GMT +1. The time now is 02:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"