vote counting

[TropicDave27]

OK...here's the problem.

We're having elections soon at our local, and I want to make a couter that I
can use to tally the votes. There's at least 2 candidates for each office
(president, v-p, sec-treas, trustees and business agent - with the exception
of recording secretary, who's running unopposed) and several of these people
are on different slates.

What I'd like to do is make a spreadsheet that allows me to click on a
command button or check box - or whatever - for each candidate, and also do
the same for each slate (which would add a vote to each candidate on the
slate). Then I could have a 'tally button' where these votes would be counted
and added to each candidate's total. I'm sure this is possible but the
programming is beyond me. Anyone have something similar out there that I
could use, or have programming that I could adapt?

Elections are next month, and I hope to have it done by then. So far I've
got the layout done but getting the buttons and boxes to work si beyond my
skill at this point. Thanks for any help!

David

 

[Ron Coderre]

Try something like this example:

A1: (a candidate name)

From the Excel Main Menu:
<view><toolbars>.....Check: Forms

Click on the Spinner Control (it has up/down arrows on it)

Now, paint a box covering all of cells A2:A3
(That creates a spinner)
Right-click on the Spinner
......Select: Format control
......Select the Control tab
......Set the Cell Link to A4
......Click [OK]

Press [ESC].....to get out of design mode.

Now....
Each time you click on the UP arrow on the spinner
1 is added to cell A4.
Each time you click on the DOWN arrow on the spinner
1 is subtracted from cell A4.

Repeat for any other candidates.

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

 

[MartinW]

And just to add to Ron's method, before starting do this.

If the Drawing toolbar is not visible at the bottom of your
screen, enable it by View>Toolbars>Drawing.

Then Click on Draw>Snap>To Grid

By setting the snap to grid option, when you paint your
spinner onto the sheet, it will automatically snap to the
gridlines on your worksheet, which makes it very simple
to keep your spinners nice and neat and a uniform size.

HTH
Martin

Try something like this example:

A1: (a candidate name)

From the Excel Main Menu:
<view><toolbars>.....Check: Forms

Click on the Spinner Control (it has up/down arrows on it)

Now, paint a box covering all of cells A2:A3
(That creates a spinner)
Right-click on the Spinner
.....Select: Format control
.....Select the Control tab
.....Set the Cell Link to A4
.....Click [OK]

Press [ESC].....to get out of design mode.

Now....
Each time you click on the UP arrow on the spinner
1 is added to cell A4.
Each time you click on the DOWN arrow on the spinner
1 is subtracted from cell A4.

Repeat for any other candidates.

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

OK...here's the problem.

We're having elections soon at our local, and I want to make a couter
that I
can use to tally the votes. There's at least 2 candidates for each office
(president, v-p, sec-treas, trustees and business agent - with the
exception
of recording secretary, who's running unopposed) and several of these
people
are on different slates.

What I'd like to do is make a spreadsheet that allows me to click on a
command button or check box - or whatever - for each candidate, and also
do
the same for each slate (which would add a vote to each candidate on the
slate). Then I could have a 'tally button' where these votes would be
counted
and added to each candidate's total. I'm sure this is possible but the
programming is beyond me. Anyone have something similar out there that I
could use, or have programming that I could adapt?

Elections are next month, and I hope to have it done by then. So far I've
got the layout done but getting the buttons and boxes to work si beyond
my
skill at this point. Thanks for any help!

David