Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Ballot Paper in Excel

0

Namaste!

I went through some google and youtube searches but found difficult to find any materials related to creating ballot paper in excel. I wonder if you could share me a link if possible.

Thanks in advance.

Answer
Discuss

Discussion

Are you trying to make a voting template in Excel?
don (rep: 1989) Aug 31, '17 at 10:39 am
@don
Yes. I'm just a learner and hope my question does not create annoyance.
To be specific, can we hide specific number of rows every time someone presses "enter" making way for the next voter? This way, I could count votes by counting the radio buttons.


Certainly, you may have a better idea about creating such templetes. Hope to get your help. Thanks!
Chhabi Acharya (rep: 111) Sep 4, '17 at 7:26 am
Add to Discussion

Answers

1
Selected Answer

The attached workbook contains a voting system you might like to use for simple voting in the clubhouse.

To set it up, enter the names of the candicates on the 'VoteCount' sheet in the range B3:Z3. Delete the results of any previous vote but keep row 4. On the 'Results' sheet pull the formula from A4:B4 down for as far as needed so that all candidate names appear in column A. Click on the green "Vote Now" button.

The vote count in column B will disappear. The 'VoteCount' sheet will be hidden (Keep it hidden during voting). A voting form will pop up. Enter your name, make a choice, and click on "Cast your vote" (or 'Cancel' to do nothing). If you have voted previously under the same name (exactly!) your vote will be rejected. If you forget to make a choice you will be reminded. If all is well your name will be registered in the 'VoteCount' sheet and an x marked for the candidate you chose. Click on Results!B3 and you will see your vote in the tally column. Click B3 again to hide the tally from the next voter.

You can make all of this much prettier, but plese don't change the columns or header rows because they are all hard-written into the VBA code that pulls the strings in the background.

Discuss

Discussion

@Variatus,
I think I am nearabout the end of my searches. It is the best help in my query! In these past few days, with my little knowledge, I tried to make some changes in your file  but to no avail. So, I wonder if these changes could be made:
# keeping the "VoteCount" sheet somewhere in another drive, separately,
# replacing the ID window with a password so that the voting officer can make the form active for each of the voters, one after another, and
# creating lists for more than one category to vote in the same form.

Sorry for making a high demand.
Chhabi Acharya (rep: 111) Sep 13, '17 at 2:20 pm
I'm glad my effort seems to have caught your attention. However, we must not pretend that this forum is a free code writing service. It's a place where people have questions and find answers. You had a question. You received an answer. You should select the answer that suits you best and close the thread.
Now you have three new questions. I think they are quite interesting. Other experts here may have opinions on them. We should put them up for discussion, one at a time. I don't recommend to run the 3 questions in parallel because each of them will demand major conceptual changes affecting the others. But if you have the patience, I believe you will end up with something quite near to what you first imagined. Just start with the one most important to you. Post the workbook, give your question an enticing caption and put forward your ideas.
Variatus (rep: 4889) Sep 13, '17 at 9:02 pm
I'm grateful to you for your help and suggestion, too. I'll try to follow your advice in future.
 Thank you!
Chhabi Acharya (rep: 111) Sep 16, '17 at 10:32 am
Add to Discussion
0

Your description is a bit vague.  You can make Word and Excel documents that use check boxes, radio buttons etc. Try doing a small amount of research of what you want, then be specific in your request.  It is often quite helpful to provide a sample file of what you want the output to look like.

Discuss

Discussion

@queue,
Thank you very much for the response. I've tried to be brief in the discussion under don's reply.
Chhabi Acharya (rep: 111) Sep 4, '17 at 7:29 am
Add to Discussion
0

You should not do any kind of serious voting in Excel. That said, you should look into making a UserForm for voting or create some sort of template in Excel where votes can be entered and then stored on a hidden worksheet.

Start by looking at our tutorial here: Input Form to Get Data and Store it in Another Tab in Excel

Once you get that working, make sure to hide the tab.

Discuss

Discussion

@don,
Thank you for the link. I got lost somewhere even if I tried to copy the steps exactly the same but hope to be successful with some more practice.
Chhabi Acharya (rep: 111) Sep 13, '17 at 2:26 pm
The tutorial has a sample file that you can download.
don (rep: 1989) Sep 25, '17 at 3:19 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login