Creating Hyperlinks in Excel using VBA

[Atecuser1]

Hi there, How do you create hyperlink in excel using VBA?

Thanks

Just an example would ber very helpful!

Thanks

 

[Anthony47]

For example:
Range("I5").Select
Selection.Hyperlinks(1).Address = "http://www.wind.com/"

or
Range("I5").Select
Selection.Hyperlinks(1).Address = ActiveCell.Value

Does it help?

Bye,

 

[abiram01]

try this also:

Range("A1").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _
"Sheet2!A1", TextToDisplay:="asdf"

 

[Anthony47]

Abiram's answer is more appropriate, as my method describe how you can MODIFY and existing link.

I should have been written (credit to Abiram01):
Range("I5").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="http://www.wind.com"

Bye,

 

[Atecuser1]

OK thanks guys it has worked wanders cheers