Hi,

I would appreciate if you can help me on this!

I have two group box (Form) --- Group1 and Group2 --- on a regular
excel spreadsheet. There are 3 option buttons in Group1 and 7 option
buttons in Group2. I must select ONE AND ONLY ONE from each group box.
What I am trying to do is: If option button 1 in Group1 is clicked,
then ONE AND ONLY ONE of all 7 option buttons in Group2 is able to be
clicked. However, if option button 2 in Group1 is clicked, then ONE
AND ONLY ONE of two option buttons in Group2 is able to be clicked
(the other 5 option buttons will be greyed out). Option button 3 in
Group 1 is similiar to Option button 2.

Thank you,

Would it work to simply turn the "Visible" property of the Group 2
options to "True" or "False" depending on the Group 1 choices?

/ T /

On Mar 7, 5:55 pm, "George" wrote:
Hi,

I would appreciate if you can help me on this!

I have two group box (Form) --- Group1 and Group2 --- on a regular
excel spreadsheet. There are 3 option buttons in Group1 and 7 option
buttons in Group2. I must select ONE AND ONLY ONE from each group box.
What I am trying to do is: If option button 1 in Group1 is clicked,
then ONE AND ONLY ONE of all 7 option buttons in Group2 is able to be
clicked. However, if option button 2 in Group1 is clicked, then ONE
AND ONLY ONE of two option buttons in Group2 is able to be clicked
(the other 5 option buttons will be greyed out). Option button 3 in
Group 1 is similiar to Option button 2.

Thank you,

On Mar 7, 8:42 pm, wrote:
Would it work to simply turn the "Visible" property of the Group 2
options to "True" or "False" depending on the Group 1 choices?

/ T /

On Mar 7, 5:55 pm, "George" wrote:



Hi,

I would appreciate if you can help me on this!

I have two group box (Form) --- Group1 and Group2 --- on a regular
excel spreadsheet. There are 3optionbuttons in Group1 and 7option
buttons in Group2. I must select ONE AND ONLY ONE from each group box.
What I am trying to do is: Ifoptionbutton1 in Group1 is clicked,
then ONE AND ONLY ONE of all 7optionbuttons in Group2 is able to be
clicked. However, ifoptionbutton2 in Group1 is clicked, then ONE
AND ONLY ONE of twooptionbuttons in Group2 is able to be clicked
(the other 5optionbuttons will begreyedout).Optionbutton3 in
Group 1 is similiar toOptionbutton2.

Thank you,- Hide quoted text -

- Show quoted text -

Thanks for your response. Could you please show me how to do this?