ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to Link 4 Option Buttons excluding all others? (https://www.excelbanter.com/excel-discussion-misc-queries/191408-how-link-4-option-buttons-excluding-all-others.html)

Sheila

How to Link 4 Option Buttons excluding all others?
 
In a series of eight questions, there are four choices for each question.
How do I link only four Option Buttons per question? (I have 32 buttons,
and they are all linked together.)

Thank you for any help.


Jim Thomlinson

How to Link 4 Option Buttons excluding all others?
 
Depends where you got the buttons from. If they came from the Forms toolbar
then you need to place a Frame control around the buttsons to group them. If
they are from the Control Toolbos then you need to put the sheet in Design
Mode and righ tclick the buttons. Select properties and Change the group name
for each set of 4 to match...
--
HTH...

Jim Thomlinson


"Sheila" wrote:

In a series of eight questions, there are four choices for each question.
How do I link only four Option Buttons per question? (I have 32 buttons,
and they are all linked together.)

Thank you for any help.


Sheila

How to Link 4 Option Buttons excluding all others?
 
That did the trick! Thanks so much, Jim.



"Jim Thomlinson" wrote:

Depends where you got the buttons from. If they came from the Forms toolbar
then you need to place a Frame control around the buttsons to group them. If
they are from the Control Toolbos then you need to put the sheet in Design
Mode and righ tclick the buttons. Select properties and Change the group name
for each set of 4 to match...
--
HTH...

Jim Thomlinson


"Sheila" wrote:

In a series of eight questions, there are four choices for each question.
How do I link only four Option Buttons per question? (I have 32 buttons,
and they are all linked together.)

Thank you for any help.



All times are GMT +1. The time now is 06:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com