How you wish to rest is up to you. A command button seems logical. In that
case attach this code

public sub ResetTo0()
range("A1").value = 0
end sub
--
HTH...

Jim Thomlinson


"Mark N" wrote:

Thanks Jim,
I forgot but i would need to reset the cell also. do i need another command
button to reset?

"Jim Thomlinson" wrote:

Place this code in a standard code module and assign it to a coomand button...

Public Sub Increment()
Range("A1").Value = Range("A1").Value + 1
End Sub
--
HTH...

Jim Thomlinson


"Mark N" wrote:

I want to assign a macro to a command button so that it increases the value
of a cell by 1
Thanks in advance if you can help me.