Click link changes the value of another cell

[dagarcia_mwc]

Need help, is there an excel formula for my problem

A1 is a hyperlink of a url
if I click the link B1 should be marked as 1

A2 is a hyperlink of a url
if I click the link B2 should be marked as 2

 

[Eric W]

Not a formula, but a macro should work. Right click on the sheet tab on the bottom and select View Code. Paste the following code into that window:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)

    If Target.Address = Range("A1").Value Then Range("B1") = 1
    If Target.Address = Range("A2").Value Then Range("B2") = 2

End Sub

This should work if it's a regular hyperlink, and not the HYPERLINK function.

 

[dagarcia_mwc]

Not a formula, but a macro should work. Right click on the sheet tab on the bottom and select View Code. Paste the following code into that window:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)

    If Target.Address = Range("A1").Value Then Range("B1") = 1
    If Target.Address = Range("A2").Value Then Range("B2") = 2

End Sub

This should work if it's a regular hyperlink, and not the HYPERLINK function.

Hello, thank you for this.

Is there a different marco for a link of sharepoint files?

Looking forward to your help again

 

[Eric W]

I can't say anything about sharepoint files, but the above macro should work for links to files on local drives.