Radio Option Buttons Both Selecting When Put in Group Box

%3CLINGO-SUB%20id%3D%22lingo-sub-2098891%22%20slang%3D%22en-US%22%3ERadio%20Option%20Buttons%20Both%20Selecting%20When%20Put%20in%20Group%20Box%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2098891%22%20slang%3D%22en-US%22%3E%3CP%3EWorking%20in%20an%20excel%20sheet%20where%20individual%20items%20need%20to%20be%20identified%20as%20belonging%20to%20one%20of%20two%20groups%20(Option%20A%20and%20Option%20B)%2C%20my%20radio%20buttons%20within%20my%20group%20box%20are%20both%20selecting%20and%20I%20cannot%20get%20them%20to%20behave%20in%20an%20%22either-or%22%20situation.%3CBR%20%2F%3E%3CBR%20%2F%3EMy%20process%20is%20this%3A%20I%20create%20an%20group%20box%2C%20and%20then%20add%20my%20option%20buttons.%20Before%20renaming%20the%20option%20buttons%2C%20I%20resize%20them%20to%20fit%20within%20the%20group%20box.%20I%20then%20rename%20them.%20There%20is%20no%20clipping%20on%20the%20name%20text%20so%20it%20doesn't%20matter%20for%20my%20purposes.%20I%20then%20proceed%20to%20click%20one%20or%20the%20other.%20I%20have%20done%20this%20successfully%20twice.%20The%20third%20time%2C%20the%20radio%20buttons%20both%20accepted%20a%20%22checked%22%20input%20simultaneously.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20no%20idea%20what%20is%20going%20on.%20I%20deleted%20the%20option%20box%2C%20recreated%20it%2C%20deleted%20the%20radio%20buttons%2C%20recreated%20them%2C%20put%20them%20in%2C%20made%20sure%20no%20cell%20was%20linked%2C%20and%20tried%20again.%20They%20both%2C%20again%2C%20allowed%20a%20%22checked%22%20input.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20tried%20tying%20one%20and%20then%20both%20options%20to%20a%20cell%20to%20see%20if%20that%20would%20help.%20It%20did%20not%2C%20and%20actually%20cause%20both%20cells%20to%20become%20tied.%20The%20moment%20you%20selected%20one%2C%20the%20other%20was%20selected.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20doing%20this%20in%20Form%20Control%20since%20I%20have%20heard%20that%20ActiveX%20can%20cause%20some%20problems%20and%20be%20a%20little%20more%20unwieldy.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2098891%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Working in an excel sheet where individual items need to be identified as belonging to one of two groups (Option A and Option B), my radio buttons within my group box are both selecting and I cannot get them to behave in an "either-or" situation.

My process is this: I create an group box, and then add my option buttons. Before renaming the option buttons, I resize them to fit within the group box. I then rename them. There is no clipping on the name text so it doesn't matter for my purposes. I then proceed to click one or the other. I have done this successfully twice. The third time, the radio buttons both accepted a "checked" input simultaneously. 

I have no idea what is going on. I deleted the option box, recreated it, deleted the radio buttons, recreated them, put them in, made sure no cell was linked, and tried again. They both, again, allowed a "checked" input. 

I tried tying one and then both options to a cell to see if that would help. It did not, and actually cause both cells to become tied. The moment you selected one, the other was selected. 

I am doing this in Form Control since I have heard that ActiveX can cause some problems and be a little more unwieldy. 

1 Reply

@Nathaniel_Polley 

Very sorry. "Both option buttons become tied." Not both cells.