Thread: hot to get a tally of the number of times a cell is clicked
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default hot to get a tally of the number of times a cell is clicked
..........
With Target
.Offset(0, 1).Value = .Offset(0, 1).Value + 1
.Offset(0, 1).Select
End With
..........

Just a comment to help save some typing...

With Target.Offset(0, 1)
.Value = .Value + 1
.Select
End With

Rick
Reply With QuoteReply With Quote