Crazy optionbuttons
I have a very weird problem with a userform and its option buttons. There are 5 identical columns of buttons, each with 14 rows. Each row is grouped with a frame. When the Calculate Scores button is hit, a grade is created below each column. It appears to be working as expected until any button in row 11 is selected. At that point, the grade does not get calculated and, this is where it gets weird, some of the option buttons in row one have either changed (yes, flat out changed to a different selection) or become "half" selected. Has anyone every seen this or have any suggestions how to fix this problem? THANKS!!
I have attached a dummy sheet.
In testing the form, try selecting the 5 button for the first 11 rows. When you hit calculate score, you should see a grade populate. Then select any button on the 12th row, hit calculate, and things will start to get crazy. If you click the 5 button, you will see a ghost selection in row one appear. If you select button 1 in that row, you will see row one actually change selections. Keep playing with selections and more changes in row one will occur.
Attachment | Size |
---|---|
Form for testing.xlsm | 40.76 KB |
Recent comments
5 years 42 weeks ago
6 years 28 weeks ago
6 years 40 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 49 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago