Excel macro problem

Closed
top - Mar 13, 2010 at 09:28 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 14, 2010 at 05:12 PM
Hello,
i am trying to ask a few simple questions in individual command buttons and the answers are going to be yes or no. I would like the answers to be stored and then evaluated at the end (ie if more than 50% answers are yes then he outcome will be yes and of the answers are more than 50 % no then the outcome will be no)

many thanks

2 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 13, 2010 at 10:15 PM
What did you meant by "individual command buttons" ?
0
hi - I think this is called a command button?
0
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 14, 2010 at 05:12 PM
Ah I see. Now I think I understand your design. Well you can have two module level variable and then on each click on yes and no, increase the appropriate variable. Once you are done, with the all the clicks, you can use these totals to find of yes or no is the final answer
0