A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Links and Linking
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing hyperlink when using lookup



 
 
Thread Tools Display Modes
  #1  
Old December 22nd, 2008, 10:02 PM posted to microsoft.public.excel.links
OX_Gambit
external usenet poster
 
Posts: 9
Default Showing hyperlink when using lookup

I have one sheet that has a list that contains some text that has hyperlinks
and then I use lookup ona different sheet, but when the text is displayed
onthe second sheet the hyperlink is not there. Is there a way of keeping the
hyperlink on the second sheet. The hyperlink uses tags.
  #2  
Old December 29th, 2008, 07:39 AM posted to microsoft.public.excel.links
Shane Devenshire
external usenet poster
 
Posts: 845
Default Showing hyperlink when using lookup

Hi,

Excel's formulas return values, they will not return the associated
hyperlink or comment or error checking message.

You might be able to right a custom VBA function that will do this for you.

Here is a sample, that doesn't quite do what you want but it might start you
on the way

Function RETURNHYPERLINK(Rng As Range) As String
If Rng.Hyperlinks.Count 0 Then
RETURNHYPERLINK = Rng.Hyperlinks(1).Address

If Len(RETURNHYPERLINK) = 0 Then
RETURNHYPERLINK = Rng.Hyperlinks(1).SubAddress
End If
End If
End Function

This function, entered as =ReturnHyperlink(A1) would return the hyperlink
of cell A1.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"OX_Gambit" wrote in message
...
I have one sheet that has a list that contains some text that has
hyperlinks
and then I use lookup ona different sheet, but when the text is displayed
onthe second sheet the hyperlink is not there. Is there a way of keeping
the
hyperlink on the second sheet. The hyperlink uses tags.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:38 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.