Forum Discussion
Problem with option button cell linking
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
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,
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.
