Excel counter

  • Thread starter Thread starter bower
  • Start date Start date
B

bower

Hello,

Can someone suggest a way to make a counter in a cell in Excel?

It needs to start at zero and increment by 1 every time the up-arrow i
hit.

Thanks
 
This example use CTRL-UP
Run the sub test one time to let the shortcut works
See Application Onkey in the VBA help for more infiormation

Sub test()
Application.OnKey "^{UP}", "yoursub"
End Sub

Sub yoursub()
Range("A3") = Range("A3") + 1
End Sub
 
bower

The use of a Spinner from the Forms Toolbar is another option.

Gord Dibben XL2002
 
Back
Top