Hi dcarr,
Copy the following code into the sheet code Project Editor. (Right click the
sheet tab and click on View Code, use ALT + TAB to get back the sheet.)
Make three buttons from the Forms tool bar and Format the text to each
candidates name.
Right click the buttons and click on Assign Macro and assign the code to the
proper button.
Bush votes are totaled in cell I2, Kerry in I3 and Nader in I4.

HTH
Regards,
Howard

Sub BUSH()
If MsgBox _
("You voted for BUSH, is that a correct choice?", _
vbYesNo, "BUSH VOTE") = vbNo Then
Exit Sub
End If
Range("I2").Value = Range("I2").Value + 1
End Sub

Sub KERRY()
If MsgBox _
("You voted for KERRY, is that a correct choice?", _
vbYesNo, "KERRY VOTE") = vbNo Then
Exit Sub
End If
Range("I3").Value = Range("I3").Value + 1
End Sub

Sub NADER()
If MsgBox _
("You voted for NADER, is that a correct choice?", _
vbYesNo, "NADER VOTE") = vbNo Then
Exit Sub
End If
Range("I4").Value = Range("I4").Value + 1
End Sub


"dcarr" wrote in message
...
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