Repetitive entries...

[abie]

I have a sheet where we have a lot of repetitive work. Basically we go through a football games play by play and count certain plays. Runs to the middle, long passes, etc.

What I want to do is have a button for each type of play and every time a user clicks a certain button, the cell count for that play goes up. I'm stuck on how to do this...anyone help out?

 

[Smitty]

Welcome to the Board!

Probably one of the easier things to do would be use a Spinner from the Forms toolbar and just link it the cell where you want to record the play.

Or if you want a button you can use something like this:

Private Sub CommandButton1_Click()
  Range("A1").Value = Range("A1").Value + 1
End SUb

Hope that helps,