Add this code to a general module and just assign the macros to your
buttons.

Dim nCounter As Long

Sub Count()
nCounter = nCounter + 1
End Sub

Sub ResetCount()
nCounter = 0
End Sub


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Sdbenn90" wrote in message
...
I need help with either Excel or Visual basic Code to do the following.

I need a command button if clicked by the user it will count the number of
time the button was clicked. Also will need a reset button so the user can
reset the number back to Zero if they need to start over. In Visual basic
I
used the Static function which works but you have to end the form or sub
to
reset the number. Any help with this matter is greatly appreciated.