Counting Radio Button Entries

[Dbeethekidd]

Hi All

Before I start building the spreadsheet I wanted to know how you count the number of specific radio button selections by a user

Basically I want to build a form with a list of options (Sales, Marketing, Support etc) that the user fills in every time they take a call to identify what type of call they received and keep a running total

For example;

If I took a call for "Sales" I would select the "Sales" radio button and that would count as 1 instance, then if I took another call for "Sales" I would again select it but the 1 would need to become a 2

After every instance it would just close/reset the form so that a new selection could be made every time and keep the total in a table in the BG

Is this possible and if further explanation is required please let me know

Thanks again everyone

[majosum]

Yes it is possible. You would need to add a counter somewhere though. For this example, let's assume that the radio button is returning it's value in cell A1 (so if Sales is selected, a 1 will appear in cell A1).

Now, let's assume the counter for Sales is in cell B1 and the counter for Support is in B2, etc. Create a macro for each radio button, so if you have two radio buttons, you will need two subs. Assign each macro to its respective radio button. Now, when the Sales radio button is selected, it will automatically run the SalesPlusOne macro which increases the counter by 1(cell B1) and resets the radio buttons. Do the same for the other radio buttons but select the other macros.

Please Login or Register  to view this content.

[Dbeethekidd]

Hi Majosum

Thanks for your reply

I've just added the macros to the radio buttons but the form itself doesn't reset and remains with the single input on the screen

Have I missed something to actually make the form reset?

Would it be worth just having a "save and close" button once the selection has been made?

Thanks

[majosum]

You could do either one. The code I gave you did not make the rest of the form reset. You would have to add that code as well. Or, if you wanted to do the "save and close" method, you could do that as well but you will have to be sure to have it reset the form as well.