option button (Form)

  • Thread starter Thread starter George
  • Start date Start date
G

George

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 /
 
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 /






- Show quoted text -

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top