Radio button group

I have grouped 4 radio buttons together. However, the group only seems to recognize 3 "options". Once I link the 4th to the same cell, it causes the first two buttons to either be selected, or deselected automagically. How do I include the 4th button so that only one is selected at a time? (this is in Excel '07, if it makes any difference)

Thanks for the help!

Assuming controls are on the worksheet.

ActiveX Controls have a GroupName property which would need to be the same for all controls. There linked cells needs to be different.

Forms controls have a LinkedCell property. And a frame is the only thing which would allow different linkedcell values.

Unfortunately I know practically nothing about ActiveX (or VBA for that matter). The ironic thing is that the example in the help file about form grouping actually shows 4 radio option buttons there.

This file is a customer survey for a construction company, so I plan on using literally dozens of sets of check boxes and radio buttons. The check boxes are easy to deal with, but grouping the radio buttons is posing a problem. I would *think* it would be easy to group as many option buttons as one would desire, but I'm not finding that to be the case.

what I meant was which control set are you using.
In xl2007 on the Developer tab is the Controls group. The Insert button displays 2 sets of controls, Forms Controls and ActiveX controls.

If you are doing this using userforms then a frame should keep the radio buttons behaving correctly.

Ah, my apologies. I'm using the forms group. I think I found the problem. I tried to group the cells *after* I had inserted the radio buttons. When I create the group then insert the radio buttons within the group box, it seems to work fine. The pathetic thing is that it took me about 2 hours to figure that out.

The grouping will happen as soon as you position a group box or a set of radio controls.

When the group box is in position set the linked cell propert of 1 of the radio controls and all the others will automatically update.