How the heck to use option buttons in 2010?!?

[Gingertrees]

In Microsoft's infinite wisdom of fixing something that wasn't broken, I no longer know how to add multiple groups of Option Buttons (Radio buttons) easily.

In 2003: I would add an Option button, remove the stupid "Option Button 1" text caption, and copy/paste however many buttons I would need. Say I want 3 groups of 2 buttons each. So I would right click 2 buttons, choose Properties, and call that group "Option Button group1". Then I'd select 2 other buttons, and call those "Option button group2" etc., repeat ad infinitum, for ever and ever, amen.

NOW I can't do that. I tried, and now I have 6 buttons that are all "connected", and I can't figure out how to change that. I tried grouping in the Drawing Tools "group" function - but that seems to do nothing.

HELP!!!!!! I can't be the only person who's incredibly frustrated by this... right?

 

[texasalynn]

see is these help
http://www.mrexcel.com/forum/showthread.php?t=464460
http://office.microsoft.com/en-us/e...frame-control-to-a-worksheet-HP010342139.aspx

 

[Asala42]

I don't use these often, but in testing I do notice that if you go into the properties of a button there is a GroupName property. They seem to default to the sheet name, but if you change this property you can regroup which option buttons are linked.

 

[Gingertrees]

If there's not a simpler way, I just finished using option buttons until they fix this. There's no way I'm writing a different routine for every single stupid yes/no question in a form - I'll be here all night.

 

[Asala42]

hmm,

It looks like if you:
- Enter Design mode
- Hold Ctrl to select several OptionButtons

You can hit Properties in the taskbar (under the developer tab next to the Design Mode button) and assign all of them to the same group name at once - rather than doing it individually.