i'm having this issue when im using excel 2010 form control. my sheet have more than one group of options so i made a form group to group my option button. in one of the group i have 6 option inside a group box (form cotrol) when i clicked option 1 to 5 it worked like a charm, but when i clicked the 6th option, the 6th option was checked and also the 5th option and the value didn't change.
the steps that i take: 1. insert group box from developer tab. 2. add option button (radio). 3. format control the cell link.
is there any mistakes in the steps that i have done?