tabulating a survey..

[Larry Wight]

I know I could set up a spreadsheet with a row for each
respondent and add the results in a variety of ways. But I
want to automate the data entry so that clicking on a cell
automatically adds one "vote" to a total. Any ideas? And
thanks in advance! Larry

 

[Henry]

Larry,

You need a UserForm with a checkbox for each question/cell.

When all the correct checkboxes have been checked, you need a CommandButton
labelled Save or Submit or something similar.

The code behind the CommandButton would be something like:

Private Sub CommandButton1_Click()

If Checkbox1.Value = True then Range("A1").Value = Range("A1").Value +1
If Checkbox2.Value = True then Range("B1").Value = Range("B1").Value +1
If Checkbox3.Value = True then Range("C1").Value = Range("C1").Value +1

Etc.......

End Sub

HTH
Henry