ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Forms: Radio buttons (https://www.excelbanter.com/excel-programming/336388-forms-radio-buttons.html)

Lowkey

Forms: Radio buttons
 
I am creating a sort of checklist form with multiple sections that contain a
choice where there is only one option. The radio button is the simplest
control to limit the choice to one. However, I can't figure out how to
"unlink" the radio buttons from each separate section, so the choices can be
exculsive of each other. For example,
Section A: Customer choice
Yes or no option
Section B: Contract Type
A, B, C, or D
Section C: Reference Number
1
2
3
4
5
6
and so on...
How do I format the radio buttons to be exclusive of each section?

Toppers

Forms: Radio buttons
 
Hi,

Use a frame (control) for each section and/or use a multi-page form.

HTH

"Lowkey" wrote:

I am creating a sort of checklist form with multiple sections that contain a
choice where there is only one option. The radio button is the simplest
control to limit the choice to one. However, I can't figure out how to
"unlink" the radio buttons from each separate section, so the choices can be
exculsive of each other. For example,
Section A: Customer choice
Yes or no option
Section B: Contract Type
A, B, C, or D
Section C: Reference Number
1
2
3
4
5
6
and so on...
How do I format the radio buttons to be exclusive of each section?


Lowkey

Forms: Radio buttons
 
How do I apply a "frame" control? A multi-page form is not an option.

"Toppers" wrote:

Hi,

Use a frame (control) for each section and/or use a multi-page form.

HTH

"Lowkey" wrote:

I am creating a sort of checklist form with multiple sections that contain a
choice where there is only one option. The radio button is the simplest
control to limit the choice to one. However, I can't figure out how to
"unlink" the radio buttons from each separate section, so the choices can be
exculsive of each other. For example,
Section A: Customer choice
Yes or no option
Section B: Contract Type
A, B, C, or D
Section C: Reference Number
1
2
3
4
5
6
and so on...
How do I format the radio buttons to be exclusive of each section?


Toppers

Forms: Radio buttons
 
On the Userform toolbox there ia "Frame" control next to the CommanBbutton.
Insert like any other control and then add in your option buttons Change the
frame caption to reflect your sections.

HTH

"Lowkey" wrote:

How do I apply a "frame" control? A multi-page form is not an option.

"Toppers" wrote:

Hi,

Use a frame (control) for each section and/or use a multi-page form.

HTH

"Lowkey" wrote:

I am creating a sort of checklist form with multiple sections that contain a
choice where there is only one option. The radio button is the simplest
control to limit the choice to one. However, I can't figure out how to
"unlink" the radio buttons from each separate section, so the choices can be
exculsive of each other. For example,
Section A: Customer choice
Yes or no option
Section B: Contract Type
A, B, C, or D
Section C: Reference Number
1
2
3
4
5
6
and so on...
How do I format the radio buttons to be exclusive of each section?



All times are GMT +1. The time now is 02:43 PM.

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