Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2007

Tip: Looking for answers? Try searching our database.

vote counting

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TropicDave27 - 15 Nov 2007 13:20 GMT
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 - 15 Nov 2007 13:55 GMT
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.
>
[quoted text clipped - 22 lines]
>
> David
MartinW - 15 Nov 2007 20:55 GMT
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:
>
[quoted text clipped - 59 lines]
>>
>> David

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.