Problem with option button cell linking

%3CLINGO-SUB%20id%3D%22lingo-sub-2530485%22%20slang%3D%22en-US%22%3EProblem%20with%20option%20button%20cell%20linking%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2530485%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20bunch%20of%20activex%20radio%20button%2Foption%20buttons%20in%20my%20excel%20spreadsheet%20form.%20Each%20of%20the%20button%20is%20cell%20link%20to%20a%20to%20an%20unique%20cell%20(e..g%2C%20button%201%20to%20b1%2C%20button%202%20to%20b2%2C%20button%202%20to%20b3%2Cetc).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20some%20unknown%20reasons%20that%20I%20can't%20figure%20out%2C%26nbsp%3B%20if%20I%20set%20the%20button%201%20to%20cell%20link%20to%20b1%2C%20then%20cell%20button%203%20to%20b3%2C%20the%20cell%20link%20value%20for%20button%201%20would%20change%20to%20b3.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20is%20like%20somehow%20the%20button%201%20and%20button%203%20are%20connected%2C%20if%20I%20change%20the%20cell%20link%20value%20in%20one%20it%20would%20change%20in%20the%20other%20button.%20This%20a%20problem%20that%20I%20have%20with%20most%20of%20the%20buttons.%20If%20I%20change%20the%20cell%20link%20value%20in%20button%202%2C%20the%20cell%20link%20value%20would%20change%20in%20button%201.%20If%20I%20change%20button%203%2C%20it%20would%20also%20change%20button%201%2Cetc%2Cetc.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2530485%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2530996%22%20slang%3D%22en-US%22%3ERe%3A%20Problem%20with%20option%20button%20cell%20linking%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2530996%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1099097%22%20target%3D%22_blank%22%3E%40chun8143%3C%2FA%3E%26nbsp%3BOption%20buttons%20are%20indeed%20%22connected%22.%20Only%20one%20can%20be%20selected%20unless%20you%20put%20every%20single%20one%20inside%20a%20Group%20box.%20But%20then%20you%20are%20affectively%20creating%20Check%20boxes.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a bunch of activex radio button/option buttons in my excel spreadsheet form. Each of the button is cell link to a to an unique cell (e..g, button 1 to b1, button 2 to b2, button 2 to b3,etc).

 

For some unknown reasons that I can't figure out,  if I set the button 1 to cell link to b1, then cell button 3 to b3, the cell link value for button 1 would change to b3. 

 

It is like somehow the button 1 and button 3 are connected, if I change the cell link value in one it would change in the other button. This a problem that I have with most of the buttons. If I change the cell link value in button 2, the cell link value would change in button 1. If I change button 3, it would also change button 1,etc,etc.

2 Replies

@chun8143 Option buttons are indeed "connected". Only one can be selected unless you put every single one inside a Group box. But then you are affectively creating Check boxes.

@chun8143 

Just agreeing with @Riny_van_Eekelen.  What you describe is an essential characteristic of an option control.  In essence, it allows the user to provide an answer to a multi-choice question.  Multiple option buttons are required for the user to provide the answer to a single question and only one button can be set at a time.

 

Another question requires a new group box and a separate set of buttons,