MrExcel.com - Your One Stop for Excel Tips & Solutions

Grouping Radio Buttons

Posted by Mark on May 31, 2001 2:57 PM

I've created a survey-like form in Excel with several questions and each has a several choices as radio buttons. I grouped the radio buttons that belonged together. However, the grouping doesn't seem to work. In fact, all the radio buttons are connected! So if I click choice A for question 1 and then click choice B for question 2, choice A for question 1 goes away. Out of all the radio buttons I have on the worksheet, only one can be selected at a time.

How can I let VBA know which radio buttons are connected and which are not?

Thanks!

Mark

Posted by Dax on June 01, 2001 4:19 AM

Hello,

If you're using the Option buttons from the Control toolbox then you can set the GroupName property for each option button. This will allow you to group each set of option buttons and they'll operrate independantly of any other groups.

Regards,
Dax.