Radio button disabled

[fgfgicare]

Dear Expert,

Do you have any idea on how to unchecked the radio button after I select the motor model as an example?
If I select Motor Model, then the Car and Lorry model has to unchecked the radio button.
Any formula or function to this matter?
Excel uploaded for your reference.

Thank you.

[ikboy]

Please Login or Register  to view this content.

[fgfgicare]

Dear ikboy,

Thank you for your codes.

Could you explain your codes?

Please Login or Register  to view this content.

Questions as below:-
1) I have done the same motor module for car and lorry module separately, how do you define the array?
2) Why the array have to be (4, 5, 6, 10, 11, 12)? What does it mean?
3) It seems that the radio button still can clicked after the motor module has created?
Do you have any data validation stated that it cannot click it?

I have uploaded the excel spreadsheet for you.

Hope to hear from you soon.

[AliGW]

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[fgfgicare]

Dear Ali,

Thank you for the warnings.

Will improve it in future.

[ikboy]

@fgfgicare,
Code Get_Shapes_Info: for get information to write array.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[fgfgicare]

Dear ikboy,

Thank you very much for your coding, and I am unable to understand your coding.

Would you mind if I can ask you from your coding?

[fgfgicare]

Hi,

I have uploaded the same spreadsheet and this time it is a little different question based on the radio button selection.

Please view the Sheet2, where there example as below: -

On the selection model – I select “Car”
On the Car Model – I select “Honda”

Approved Custom Changes: -
Door – Radio button: Yes
Window – Radio Button: No
Color- Radio Button: Yes
Bumper- Radio Button: No
Skirting – Radio Button: No

If I select the Lorry from selection model group box, the car model group box and approved custom changes group box will be disabled and no one can select for these two group boxes as this is for car model only.

Could you guide me?

Thanks.

[ikboy]

The easy way to write your code with needs.
Alt+F10 open the shapes menu amend the option buttons names.

Please Login or Register  to view this content.

[fgfgicare]

@fgfgicare,
Code Get_Shapes_Info: for get information to write array.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Dear ikboy,

Thank you for your coding. We are nearly there.

Could you use this method as the above quote for the excel Sheet2 as I am confused on the array?

Hope to hear from you.

[ikboy]

Please Login or Register  to view this content.

HTH

[fgfgicare]

Dear ikboy,

Thanks for your coding.

Could you realign the coding on the car selection whereby I can reselect the car model and reselect the approved custom changes?

Please Login or Register  to view this content.

I tried to change the CarOptions as the code above but there is an error message Attachment 689222

May I ask where should I correct it?

[ikboy]

@fgfgicare,
Use my code “Get_Shapes_Info” or Alt+F10 to open the shapes menu to understand all option buttons what does. As required to write or say what your need lets other to help.

[fgfgicare]

Dear ikboy,

Thanks a lot.