LinkBack URL
About LinkBacks
I want to use a formula/function/VBA-script to count the times that I click on a hyper- or weblink in an EXCEL table.
Does anybody has a solution?
I want to use a formula/function/VBA-script to count the times that I click on a hyper- or weblink in an EXCEL table.
Does anybody has a solution?
you can put this in the worksheet object:
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) Range("A1").Value = Range("A1").Value + 1 End Sub
Hope I could help - if your post has been solved don't forget to mark it as such.
Clicking the * below is a great way to say thanks!
"Drowning in 10 feet of water isn?t any different than drowning in a million feet. And if you can swim, it doesn?t matter how deep the ocean is. At some level, once you realize you?re in water that?s too deep to stand, you have to have a very different approach," - Joi Ito
Worked perfectly. Thx!!
Hi, I am 5 years late to this post. I would like to do the same as well, but I don't know how to use the VBA script. Could anyone explain?I am so sorry for my confusion.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks