follow hyperlink event

[greg.begin]

I have a hyperlink in my worksheet. the hyperlink goes to a website, when it goes to the website I can search for an address. I have the address 5 columns to the left of this hyperlink, I want to be able to allow the person to select the hyperlink but have vba copy the address, so when they go to the website, they only have to hit crtl+V and the address populates in the search box on the website. I did it with a selection_change event, and put my target the column the hyperlinks are in, however, anytime I want to make a change to that column it runs the code, of which I don't want. I want to be able to copy the address before the hyperlink runs. any ideas on how to do that? Thanks.

 

[Deepak]

Pls share the sample workbook to understand it better.

 

[Marc L]

Unclear but where is the code ? Must post it !

Could be done without any hyperlink …

_____________________________________
Je suis Charlie
​

 

[NARAYANK991]

Hi Greg ,

See if this helps.

Refer the following 2 links for more information :

http://excel-macro.tutorialhorizon.com/vba-excel-putting-text-in-the-windows-clipboard/

http://www.excelforum.com/excel-programming-vba-macros/353942-how-do-i-reference-dataobject.html

Narayan

 

[Marc L]

I was thinking to automate IE - or best by a request - avoiding clipboard …
​