Ungrouping radio buttons in Excel

[mohtogh]

Hi there,
In a Excel spreadsheet,I have two questions,that each question need two radio buttons: yes and No
(Totally 4 radio buttons). But when I put these radio buttons, Excel supposed they are all in one group (It allow me to click on just one of them). How can I separate the two pairs of (Yes/No0radio buttons?

Thanks

 

[cowski]

Put each pair in a frame control (or any control that can act as a container eg picture box, frame, etc).

 

[macajm]

Open the Control Toolbox and select design mode
then click properties.
Then choose each radio button in turn and find the "GroupName" property which you should set to a different name for each group of buttons.
eg if buttons 1 & 2 are to be grouped together, give them both the GroupName property (say) "Group1", and if buttons 3 & 4 are to be grouped together, give them both the GroupName property (say) "Group2". Then exit design mode.

 

[mohtogh]

Thanks