2

I have two groups of radio buttons on the same Excel worksheet that I want them to work exclusively from each other.

I tried to search online for answers, and got to know there was GroupName Property which can be used to group the radio buttons, however, I haven't been able to locate this property.

Can anyone tell me how to find it?
There is only object positioning under the property tab of the format control window.

Jonas
  • 121,568
  • 97
  • 310
  • 388
sjj
  • 31
  • 1
  • 4

2 Answers2

1

You need to add a group box control and then insert the radio buttons into that group box.

See here for more info: Add a group box or frame control to a worksheet

Pᴇʜ
  • 56,719
  • 10
  • 49
  • 73
0

Use ActiveX controls enter image description here

and in developer mode right click on RadioButton

enter image description here

and in properties box enter image description here

Wojciech Wojtulewski
  • 187
  • 3
  • 2
    Many user's computers by default won't trust ActiveX. So I would stay away from ActiveX if possible. And you can use a normal form control if you use group boxes. Also see [What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?](http://stackoverflow.com/questions/15455179/what-is-the-difference-between-form-controls-and-activex-control-in-excel-20) – Pᴇʜ May 05 '17 at 11:27