Ungrouping radio buttons in Excel

Question

Ungrouping radio buttons in Excel

mohtogh (Chemical)

(OP)

23 Mar 04 15:41

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 (Mechanical) · Answer 1 · 2004-03-23 15:55:05

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

macajm (Mining) · Answer 2 · 2004-03-23 21:32:37

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 (Chemical) · Answer 3 · 2004-03-23 22:42:10

RE: Ungrouping radio buttons in Excel

mohtogh (Chemical)

(OP)

23 Mar 04 22:42

Thanks

Come Join Us!

Posting Guidelines

Ungrouping radio buttons in Excel