I Need A Counter

[Guzzlr]

Hello All,
I have two Active X buttons which runs my game: one runs the game, and the other ends the game. How can I install a counter (any cell I want) to count the number of times, every time I push the run game button, and then reset itself to zero when I push the end game button?
Excel 2010
Developer tab enabled
Thanks for the help
Charles

 

[Scott Huish]

I used cell A1, but it is pretty straightforward:

Private Sub CommandButton1_Click()
Range("A1") = Range("A1") + 1
End Sub
 
Private Sub CommandButton2_Click()
Range("A1") = 0
End Sub

 

[Guzzlr]

Thanks for the reply...
I understand the code, but I dont know how to tell which one is command button1 & which one is command button 2...becasue I also have two other buttons, 4 total buttons; where do I find that information out in the develooper tab?
Thanks
Charles

 

[Scott Huish]

Right click on the control and click on Properties, you can give the buttons more meaningful names here as well.

 

[Guzzlr]

Thanks for the response, apparently the creator of the game made the buttons into pictures...not sure how he did that. Anyway, if you wish to see this thing, (and wish to spend any time with it) Ive put it into dropbox (link below) all I need is a counter in one of the cells, so I know how many times I push the "Next Week" button. The "Play Again" button is the button that when pushed, the counter will reset to zero.
The game defaults to a password protected document, however, there is no password, unprotect sheet works fine.
thanks for your time
Charles Reichert
By the way, I don't plan on publishing this thing, or any type of plagiarism, it's just for personal use, so I don't believe adding a counter in one of the cells will harm anybody...

http://dl.dropbox.com/u/38041434/Game Time!.xlsm