I have a spreadsheet that asks 20 Yes, No or N/A questions. I added radio active x controls for each yes, no or n/a answer, but I am can only select one for all the questions, not one for each question. Does anyone know how to fix that? TIA!
I have a spreadsheet that asks 20 Yes, No or N/A questions. I added radio active x controls for each yes, no or n/a answer, but I am can only select one for all the questions, not one for each question. Does anyone know how to fix that? TIA!
Can you attach a sample workbook with your radioactive ActiveX controls?
If posting code please use code tags, see here.
Here it is, I hope.
On each row right click one of the option buttons and select Properties...
You should now see the Property sheet for that button.
Select the other option buttons in the row by holding down CTRL and left clicking.
Set the GroupName property of the selected buttons to something appropriate.
Repeat for the other rows of buttons, giving each set a unique GroupName.
I did that, but now I get a Run-Time error '9': subscript out of range. My coding isn't working now. What I am trying to accomplish is. A user has to answer these questions. If at any point they select no, I want the pass to change to fail and turn red, then they know that they can not go any further. Well they can go ahead and complete the form, but they need to fix the errors that show up as failed.
Triscia
You never mentioned any code.
I've looked a the code and the change I suggested should have no impact on it.
Where does it fail and under what circumstances?
If the user selects No on any question, it will read FAIL
I thought the error was 'Subscript out of Range'?
That is the error when I try to select the q2 button. I get that error and then cell c20 doesn't change to fail because I selected No for q2.
Which line of code does it fail on?
Also which button is the q2 button? The questions aren't numbered.
I figured it out. I actually copied the code from another workbook and I needed to change the name of the sheet in the code. Our tabs were named different, so that was the issue. I believe that I have it now. Thank you for all of your help. I love this forum. It helps so much. Thanks again.
You could avoid the error by replacing ActiveSheet with Me and not using Sheets("Sheet1").Activate.
Me refers to the worksheet the buttons are on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks