Add value to cell when clicking on hyperlink/cell

[Ramballah]

Hi everyone,

I am working in a sheet that whenever I click on a hyperlink, I then need to fill in the column next to it "Ja" meaning that I opened the hyperlink.
This has been very tedious for me especially since I got hundreds left to do.
Is there a way that when I click on the link in B2 for example that cell C2 will go from empty to "Ja"

I downloaded it from spreadsheets to Excel 365. I know I have a duplicate thread in a different section but I simply am not getting a response there and I don't have a whole lot of time. I can't delete my thread either afaik.

Here's an example.

Thanks in advance,
Ramballah

 

[Ramballah]

Bump....

 

[navic]

Perhaps this idea
Instead of entering text in an adjacent cell, try using VBA to change the cell color after clicking the hyperlink.

Highlight the cell after clicking on the hyperlink in the cell

Hello experts, I have an excel table which has hyperlinks in column D. I want to change the color of the cell to green after clicking on the hyperlink. What I want is not to highlight the active cell. I want the cell to have its color permanently after clicking on the hyperlink once. Can...

www.mrexcel.com

 

[Ramballah]

Perhaps this idea
Instead of entering text in an adjacent cell, try using VBA to change the cell color after clicking the hyperlink.

Highlight the cell after clicking on the hyperlink in the cell

Hello experts, I have an excel table which has hyperlinks in column D. I want to change the color of the cell to green after clicking on the hyperlink. What I want is not to highlight the active cell. I want the cell to have its color permanently after clicking on the hyperlink once. Can...

www.mrexcel.com

No can do, a robot checks the file for "Ja" and once its "Ja" theres the conditional formatting. So I need it to say Ja.

 

[Joe4]

Maybe try using the "Worksheet_FollowHyperLink" event procedure code in VBA?

If you right-click on the sheet tab name at the bottom of the sheet, and select "View Code", and paste this VBA code in the resulting VB Editor window:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    ActiveCell.Offset(0, 1) = "Ja"
End Sub

then whenver you click on a hyperlink on that sheet, it will put "Ja" in the column just to the right of that hyperlink.

 

[Ramballah]

Maybe try using the "Worksheet_FollowHyperLink" event procedure code in VBA?

If you right-click on the sheet tab name at the bottom of the sheet, and select "View Code", and paste this VBA code in the resulting VB Editor window:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    ActiveCell.Offset(0, 1) = "Ja"
End Sub

then whenver you click on a hyperlink on that sheet, it will put "Ja" in the column just to the right of that hyperlink.

Ill test this once New Years Eve passed. Have a nice holiday!

 

[Joe4]

Ill test this once New Years Eve passed. Have a nice holiday!

Oh, OK. I thought you were in a hurry.

I don't have a whole lot of time

Enjoy your New Years!

 

[jiwleini]

Perhaps this idea
Instead of entering text in an adjacent cell, try using VBA to change the cell color after clicking the hyperlink.

Highlight the cell after clicking on the hyperlink in the cell

Hello experts, I have an excel table which has hyperlinks in column D. I want to change the color of the cell to green after clicking on the hyperlink. What I want is not to highlight the active cell. I want the cell to have its color permanently after clicking on the hyperlink once. Can...

www.mrexcel.com

Cinema HD V2 APK on Firestick, Nvidia Shield, PC & Android

Thank you very much for the solution.

 

[Ramballah]

Maybe try using the "Worksheet_FollowHyperLink" event procedure code in VBA?

If you right-click on the sheet tab name at the bottom of the sheet, and select "View Code", and paste this VBA code in the resulting VB Editor window:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    ActiveCell.Offset(0, 1) = "Ja"
End Sub

then whenver you click on a hyperlink on that sheet, it will put "Ja" in the column just to the right of that hyperlink.

this works, thanks