Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to count the clicks in any of a large range of cells in one column.
This is for purposes of collecting clicks like a person making hash marks on an inventory count sheet. There is some brilliant code on another forum but it only works on a couple or a few cells, as named within the code. I cannot make it work throughout a column. This is the code: Option Explicit Dim oldvalue As Double Private Sub Worksheet_SelectionChange(ByVal target As Range) If target.Address = "$A$5" Or target.Address = "$B$5" Then oldvalue = target Application.EnableEvents = False If target.Value = 0 Then oldvalue = 0 target.Value = 1 + oldvalue oldvalue = target.Value Application.EnableEvents = True End If End Sub Sub fixit() Application.EnableEvents = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Repetitive keystrokes and/or mouse clicks | Excel Discussion (Misc queries) | |||
Double clicks do not open the file | Excel Discussion (Misc queries) | |||
How to have errr msg pop up when user clicks on locked cell | Excel Discussion (Misc queries) | |||
auto hiding rows under category heading unless cursor clicks on to | Excel Discussion (Misc queries) | |||
unable to open Excel file by double clicks | Excel Discussion (Misc queries) |