Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Option Buttons/Radio Buttons | New Users to Excel | |||
radio Buttons | Excel Discussion (Misc queries) | |||
Help - Radio Buttons | Excel Worksheet Functions | |||
Help - Radio Buttons | Excel Worksheet Functions | |||
VBA: Disable Frame and Radio Buttons based on Another Radio Button Being True | Excel Worksheet Functions |