Forum Discussion
Using form controls
Hi Andrew_RW
Did you create a copy for the control boxes or you created each box for each question?
It's possible they are linked together if they were created by copying from another box.
You can share the file after removing confidential information, so we can have a look.
Cheers
Thanks wumolad
I've just replied to my self! New to this! I thought I had set them up differently but maybe not.
Here's the file.
There is only 1 option button in the file, what did you say was the issue in the initial message?
How about an option that doesn't require VBA. Just uses Data Validation for the drop down, and then a simple formula to put the 1 in the appropriate box. Here's the formula I put in cell D3 in the attached (I deleted the macro-dependent rows since this was just a demo):
=IF($B3=D$2,1,0)
That formula, copied to all the other relevant cells, compares the answer selected with the column heading.
I will admit to being biased against macros. There are times when they may be essential, but it's often possible to create a simpler and equally effective solution with Excel's pre-existing functions (and a smaller file to boot).
Hi wumolad
I have 20 questions for which I have 4 options for each question. I am trying to get one set of 4 options for each question but every time I try to start a new set of control boxes for a new question it links with the previous 4 control boxes. When I try to start a new option box it says 'Option Box 33' etc
Any ideas?
