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