insert a hyperlink into excel 2007 using VBA

Question

My worksheet "input" range "B11" has generated the destination URL:

file:///C:/Results/H1230-01%20VEF%201288.doc

My worksheet "input" range "B10" has generated the text:

H1230-01 VEF 1288

How can I automatically insert the hyperlink of the destination URL with the displayed text in a cell?:

Worksheets("VEF").Range("m65536").End(xlUp).Offset(1, 0).Select

Daniel · Accepted Answer · 2012-10-01 15:13:56Z

2

Use the HyperLink formula example:

=HYPERLINK("path","Text To Display")

Or with code:

Range.Formula = "=HYPERLINK(""path"",""Text To Display"")

or Using your actual references use this formula:

=HYPERLINK(B11,B10)

answered Oct 1, 2012 at 15:13

Daniel

13.1k3 gold badges39 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

kamelkid2 Over a year ago

thank you - i wasnt aware of this function. i have no need to do this through VBA now. cheers!

Jook · Accepted Answer · 2012-10-01 15:15:55Z

1

Also you could use the Hyperlink.Add method, like in this example from Excel-Help

With Worksheets("VEF")
    .Hyperlinks.Add Anchor:=.Range("m65536").End(xlUp).Offset(1, 0), _
        Address:=.Range("B11"), _
        ScreenTip:="Microsoft Web Site", _
        TextToDisplay:=.Range("B10")
End With

With Worksheets(1)
    .Hyperlinks.Add Anchor:=.Range("a5"), _
        Address:="http://example.microsoft.com", _
        ScreenTip:="Microsoft Web Site", _
        TextToDisplay:="Microsoft"
End With

answered Oct 1, 2012 at 15:15

Jook

4,7523 gold badges31 silver badges54 bronze badges

Collectives™ on Stack Overflow

insert a hyperlink into excel 2007 using VBA

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related