Hi All,
Really on red alert for some experts on macros. the link redirects to the workbook I've worked on. It's a voting poll using userform of which have 2 dependant combo boxes on the voters on Page 1 while Page 2 are the nominees. I will say that I'm still a beginner in macro excel and much of what is attached comes from the previous post thread and also some from other websites on excel macros. So, I would really appreciate for the exact macros and where to paste it.
https://www.dropbox.com/s/9bsx65wjlr5crcs/Sample.xls
The additional requests from my employer are 2 things:-
1. After Voted, the Voter should be out from the Voters List. The original macro does this, but without the dependant combo box to choose dept first then Name. When I manage to get the macros to allow dependant values, I just don't know how to modify the original macro to take off the name after voted. I've tried for days, the name who already voted are still there when the next voter use the userform.
2. Vote Count should be 2 when the Voter votes for the nominee who is not from the same department as s/he is. e.g. I'm from IT Dept, when I vote for a nominee which is from HR dept, that nominee should have 2 vote counts, but if I vote a nominee who is also from IT dept, the nominee will get only 1 vote count.
Please help as I really must complete this by Mon, 16/6/2014.
Thank you in advance.
Bookmarks