Creating a Survey or Vote

[dragonmouse]

I'm trying to create a worksheet for a Luncheon choice in our workcenter.

I would like to offer 4 choices, each user clicks on a choice and at the end I can calculate the winning choice. Maybe I haven't had enough coffee but I can't even remotely figure this out.

 

[dragonmouse]

Looking at this post it doesn't look very clear what I'm hoping for:

Column A would say:

A1: Chilies
A2: Bob's Barbeque
A3: Julies Kitchin
A4: Fast Eddies

Column B:

Would have the ab
ility for someone to "CLICK" and it would add a "vote".

 

[dragonmouse]

Bump

 

[grawls44]

Hi,

Range("C1").value=Range("C1").value+1

put that in the code for the button and it will keep a total in "C"

Greg