Conditional Hyperlinks?

**Mhz** · 02-23-2007, 09:02 PM

Hi once again,

Is Conditional Hyperlinks Possible?

Example: Clicking on a Hyperlink may result in different Hyperlinks based
on a cells value etc.

If 'A1' = 'This' then open 'This' Hyperlink.
If 'A1' = 'That' then open 'That' Hyperlink.

Just Courious as to how this can be done.. Thanks..

**raypayette** · 02-24-2007, 02:11 AM

Place a button on the sheet and assign it this macro:
Sub Macro1()
If Cells(1, 1) = "This" Then
'Web hyperlink
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"http://www.google.com/", TextToDisplay:="Google"
ElseIf Cells(1, 1) = "That" Then
'File hyperlink
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"C:\This is it.txt", TextToDisplay:="Text"
End If
End Sub

**Mhz** · 02-24-2007, 02:33 AM

Thanks Ray! ... This Is very useful!

I am going to play around with it
a bit to grasp a better understanding on using it...

This was very helpful.. Thanks Alot!

**Mhz** · 02-24-2007, 02:48 AM

Ray, what would I change or take out of the Macro to have direct
access to The File or link when it is ran?

Example: Once the Macro is ran, and either condition is true, I want that
condition carried out directly without the Anchoring of text.

Thanks In Advance..

Conditional Hyperlinks?

LinkBack

Thread Tools

Rate This Thread

Display

Conditional Hyperlinks?

Thanks Very Much!

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions

X vBulletin 4.1.8 Debug Information