Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Hyperlink - text, screen tip & link from other cells
Howdy
I want a cell in my spreadsheet to have text come from cell A1 (which is easy to do obviously), a 'screen tip/text to display' from cell B1, and the hyperlink URL to come from cell C1. Then I am going to copy this cell down the page because I have a whole series of text/screentip/hyperlinks that I want to do this way. Can I do this, and if so how? Thanks Cheers Matt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Hyperlink - text, screen tip & link from other cells
Hi
do you mean =HYPERLINK(C1,B1) -- Regards Frank Kabel Frankfurt, Germany "Matt Jensen" schrieb im Newsbeitrag ... Howdy I want a cell in my spreadsheet to have text come from cell A1 (which is easy to do obviously), a 'screen tip/text to display' from cell B1, and the hyperlink URL to come from cell C1. Then I am going to copy this cell down the page because I have a whole series of text/screentip/hyperlinks that I want to do this way. Can I do this, and if so how? Thanks Cheers Matt |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Hyperlink - text, screen tip & link from other cells
Thanks Frank
Not exactly... I mean =HYPERLINK(C1,A1) except that I was also to hoping to specify the 'Screen Tip' (you'll see the 'Screen Tip' button in the top right of the 'Insert Hyperlink' dialogue box) from another cell (b1 in this example). Hmmm, not looking too hopeful Thanks Cheers Matt "Frank Kabel" wrote in message ... Hi do you mean =HYPERLINK(C1,B1) -- Regards Frank Kabel Frankfurt, Germany "Matt Jensen" schrieb im Newsbeitrag ... Howdy I want a cell in my spreadsheet to have text come from cell A1 (which is easy to do obviously), a 'screen tip/text to display' from cell B1, and the hyperlink URL to come from cell C1. Then I am going to copy this cell down the page because I have a whole series of text/screentip/hyperlinks that I want to do this way. Can I do this, and if so how? Thanks Cheers Matt |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Hyperlink - text, screen tip & link from other cells
Matt
To get the tooltip you want, I think you'll have to have a macro that inserts a hyperlink instead of using the HYPERLINK worksheet function. Post back if you want to explore that option. -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com Matt Jensen wrote: Thanks Frank Not exactly... I mean =HYPERLINK(C1,A1) except that I was also to hoping to specify the 'Screen Tip' (you'll see the 'Screen Tip' button in the top right of the 'Insert Hyperlink' dialogue box) from another cell (b1 in this example). Hmmm, not looking too hopeful Thanks Cheers Matt "Frank Kabel" wrote in message ... Hi do you mean =HYPERLINK(C1,B1) -- Regards Frank Kabel Frankfurt, Germany "Matt Jensen" schrieb im Newsbeitrag ... Howdy I want a cell in my spreadsheet to have text come from cell A1 (which is easy to do obviously), a 'screen tip/text to display' from cell B1, and the hyperlink URL to come from cell C1. Then I am going to copy this cell down the page because I have a whole series of text/screentip/hyperlinks that I want to do this way. Can I do this, and if so how? Thanks Cheers Matt |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Hyperlink - text, screen tip & link from other cells
Hey Dick
Yep that'd be great, a macro is fine. I've played with it but so far only been able to set the hyperlink to link to another part of my worksheet. Any info would be great. Thanks Cheers Matt "Dick Kusleika" wrote in message ... Matt To get the tooltip you want, I think you'll have to have a macro that inserts a hyperlink instead of using the HYPERLINK worksheet function. Post back if you want to explore that option. -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com Matt Jensen wrote: Thanks Frank Not exactly... I mean =HYPERLINK(C1,A1) except that I was also to hoping to specify the 'Screen Tip' (you'll see the 'Screen Tip' button in the top right of the 'Insert Hyperlink' dialogue box) from another cell (b1 in this example). Hmmm, not looking too hopeful Thanks Cheers Matt "Frank Kabel" wrote in message ... Hi do you mean =HYPERLINK(C1,B1) -- Regards Frank Kabel Frankfurt, Germany "Matt Jensen" schrieb im Newsbeitrag ... Howdy I want a cell in my spreadsheet to have text come from cell A1 (which is easy to do obviously), a 'screen tip/text to display' from cell B1, and the hyperlink URL to come from cell C1. Then I am going to copy this cell down the page because I have a whole series of text/screentip/hyperlinks that I want to do this way. Can I do this, and if so how? Thanks Cheers Matt |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Hyperlink - text, screen tip & link from other cells
Matt
This puts hyperlinks in column D. You can run it as often as you like because it deletes existing hyperlinks before it creates the new one. Sub MakeHLs() Dim rCell As Range Dim rRng As Range 'The range to fill will start in D1 and end in column D as far down 'as there is data in column A With ActiveSheet Set rRng = .Range("D1", .Cells(.Rows.Count, 1).End(xlUp).Offset(0, 3)) End With 'Loop through all the cells For Each rCell In rRng.Cells 'Delete any existing hyperlinks Do While rCell.Hyperlinks.Count 0 rCell.Hyperlinks(1).Delete Loop 'Add a hyperlink rCell.Hyperlinks.Add _ anchor:=rCell, _ Address:=rCell.Offset(0, -1).Value, _ ScreenTip:=rCell.Offset(0, -2).Value, _ TextToDisplay:=rCell.Offset(0, -3).Value Next rCell End Sub -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com Matt Jensen wrote: Hey Dick Yep that'd be great, a macro is fine. I've played with it but so far only been able to set the hyperlink to link to another part of my worksheet. Any info would be great. Thanks Cheers Matt "Dick Kusleika" wrote in message ... Matt To get the tooltip you want, I think you'll have to have a macro that inserts a hyperlink instead of using the HYPERLINK worksheet function. Post back if you want to explore that option. -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com Matt Jensen wrote: Thanks Frank Not exactly... I mean =HYPERLINK(C1,A1) except that I was also to hoping to specify the 'Screen Tip' (you'll see the 'Screen Tip' button in the top right of the 'Insert Hyperlink' dialogue box) from another cell (b1 in this example). Hmmm, not looking too hopeful Thanks Cheers Matt "Frank Kabel" wrote in message ... Hi do you mean =HYPERLINK(C1,B1) -- Regards Frank Kabel Frankfurt, Germany "Matt Jensen" schrieb im Newsbeitrag ... Howdy I want a cell in my spreadsheet to have text come from cell A1 (which is easy to do obviously), a 'screen tip/text to display' from cell B1, and the hyperlink URL to come from cell C1. Then I am going to copy this cell down the page because I have a whole series of text/screentip/hyperlinks that I want to do this way. Can I do this, and if so how? Thanks Cheers Matt |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell Hyperlink - text, screen tip & link from other cells
Cheers mate - looks great
Thanks Matt "Dick Kusleika" wrote in message ... Matt This puts hyperlinks in column D. You can run it as often as you like because it deletes existing hyperlinks before it creates the new one. Sub MakeHLs() Dim rCell As Range Dim rRng As Range 'The range to fill will start in D1 and end in column D as far down 'as there is data in column A With ActiveSheet Set rRng = .Range("D1", .Cells(.Rows.Count, 1).End(xlUp).Offset(0, 3)) End With 'Loop through all the cells For Each rCell In rRng.Cells 'Delete any existing hyperlinks Do While rCell.Hyperlinks.Count 0 rCell.Hyperlinks(1).Delete Loop 'Add a hyperlink rCell.Hyperlinks.Add _ anchor:=rCell, _ Address:=rCell.Offset(0, -1).Value, _ ScreenTip:=rCell.Offset(0, -2).Value, _ TextToDisplay:=rCell.Offset(0, -3).Value Next rCell End Sub -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com Matt Jensen wrote: Hey Dick Yep that'd be great, a macro is fine. I've played with it but so far only been able to set the hyperlink to link to another part of my worksheet. Any info would be great. Thanks Cheers Matt "Dick Kusleika" wrote in message ... Matt To get the tooltip you want, I think you'll have to have a macro that inserts a hyperlink instead of using the HYPERLINK worksheet function. Post back if you want to explore that option. -- Dick Kusleika Excel MVP Daily Dose of Excel www.dicks-blog.com Matt Jensen wrote: Thanks Frank Not exactly... I mean =HYPERLINK(C1,A1) except that I was also to hoping to specify the 'Screen Tip' (you'll see the 'Screen Tip' button in the top right of the 'Insert Hyperlink' dialogue box) from another cell (b1 in this example). Hmmm, not looking too hopeful Thanks Cheers Matt "Frank Kabel" wrote in message ... Hi do you mean =HYPERLINK(C1,B1) -- Regards Frank Kabel Frankfurt, Germany "Matt Jensen" schrieb im Newsbeitrag ... Howdy I want a cell in my spreadsheet to have text come from cell A1 (which is easy to do obviously), a 'screen tip/text to display' from cell B1, and the hyperlink URL to come from cell C1. Then I am going to copy this cell down the page because I have a whole series of text/screentip/hyperlinks that I want to do this way. Can I do this, and if so how? Thanks Cheers Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I keep a hyperlink valid if the link to cell is moved? | Excel Discussion (Misc queries) | |||
Hyperlink to link to text, not just a cell | Excel Worksheet Functions | |||
How can I fix HYPERLINK(B2,E2) to the resulting text and link? | Excel Discussion (Misc queries) | |||
hyperlink - link one cell to another in a worksheet. how? | Excel Worksheet Functions | |||
Using paste link infromation in cell to hyperlink to source cell? | Excel Worksheet Functions |