CODEWITHSUNDEEP
excelradio-button
sjj
sjj

Reputation: 31

Group radio buttons on Excel

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.

Upvotes: 2

Views: 4162

Answers (2)

Wojciech Wojtulewski
Wojciech Wojtulewski

Reputation: 187

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

Upvotes: 0

Pᴇʜ
Pᴇʜ

Reputation: 57703

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

Upvotes: 1

Related Questions