VBA Hyperlink

[mmenofy]

Hi Guys,

I am asking about hyperlink function in VBA, I have the following

Label1 = "Link from excel cell"
I need to add hyperlink to it and i did the following
ThisWorkbook.FollowHyperlink Label1
and it works perfect, but what i need is (Friendly name) not to put the link shown in excel cell

Any help !!

 

[welshgasman]

I would have thought you would make the cell a hyperlink?

https://stackoverflow.com/questions/36796608/create-hyperlink-from-cell-contents-in-excel-vba