I would trap the event click of the sheet in a cell

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Then I would test the target column to see which column was used

then I would use a select statement to see if which person to increase the
date.

If you are not familiar with sheet events you can email me at
where you take out the no spam. Send me the
spreadsheet and I can do if for you in about 5 min. Anything to teach
children to vote works for me!!!

Please put a title of Children Pres Election

Good Luck

Stewart Rogers


"dcarr" wrote:

Hi! Help!! I'm a Tech coordinator at an elementry school. We have a
SmartBoard whiteboard and we want to use it to hold a mock presidential
election. In an Excel 2002 spreadsheet I have the candidates pictures in A1,
A2 and A3. Their names appear in B1, B2 and B3. What I need to set up is to
have a macro (I guess?) that will detect a click (or touch) in either C1, C2
or C3 and record a one (1) in the corresponding D1, D2 or D3 box (which are
all off the screen on the right - out of sight). Then I need a macro or
formula to add each additional vote (or one) for that candidate to the
acculumating total in D1, D2 or D3 (-- or E1, E2 or E3 if necessary).
Basically, I'd like the students to walk up to the SmartBoard and be able
to touch the screen (the same as mouse clicking in a cell) in a box next to
their candidate to vote for him and have that "vote" recorded and totaled in
a cell that is off the screen to the right. Thus each time a student touches
or "clicks" on a selection box, a vote is recorded for that candidate.
I was told by the people at Microsoft that this is possible using a very
simple Visual Basic macro and I went to the following web page, but I could
not make sense of it or make it work:
http://support.microsoft.com/default...b;en-us;143345
The kids and I would really appreciate any help with this that you may
offer. Time is short as we have to hold this mock election on Friday, Oct.
29!! Thank you in advance, Dcarr