Topic: insert Hyperlink in Excel to another cell in Excel

[David Hall]

I have searched everywhere I can, and I have not been able to find how to hyperlink from a cell on Sheet1 to a cell on Sheet2 via VBA.  I have an example that works if typed exactly the way they show, but if I try to switch out for my tab names, it crashes.  I will post the code that works (got to go copy it from the site i found it on

[David Hall]

Code: [Select]

Sheets("Sheet3").Hyperlinks.Add Sheets("Sheet3").Cells(3, 3), "", Sheets("Sheet1").Name & "!B2", "", "Hello"

[Matt__W]

Try this. Substitute "SHEET 1" and "THIS IS SHEET 3" with your sheet names.

Code: [Select]

Sub Test()
    Sheets("This is sheet 3").Select
   
    Range("C3").Select
    ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
        "'Sheet 1'!B2"
    ActiveCell.FormulaR1C1 = "'Hello"
End Sub

[David Hall]

Well it took a while, but your example worked GREAT!  thanks

[Matt__W]

You're welcome

[accent@pdq.net]

We are looking for AutoCad VBA consultant. We developed a Visual Basic plug-in for AutoCad, which works well on AutoCad 12 WindowsXP. AutoCad limited the Visual Basic support for AutoCad 13 (maybe 14 as well), but re-introduced for  AutoCad 2015. We need some VBA programming support for our AutoCad plug-in for 64-bit Windows 7 and AutoCad 15+.

Please contact me.

Mark
Universe Technical Translation, Inc.
mark@universe.us
713-8278800