How to Enable/Disable the Option Button(s) based on different ComboBox Values?

Dear Forum,

In a USER FORM , i have a combo box with different values and based on these values I want certain Option Buttons Enabled and Disabled.

So what code do I write and also I want to know that based on certain Option Button Clicks I want to Enable and Disable a Frame..

For Ex:
Option Button 1 Click

Frame4 is Enabled but when any other Option Button is Clicked then this should be disabled again so do I need to write the Frame4.Enabled = False for every other Option Button other than 1 or is there a better of way doing this...

Like I want the Frame to Enabled only when the Opt Button 1 is clicked and not otherwise so please sugges me the above two things..

1. To manouvere the Option BUttons on the Combo Values
2. To Control the Enable and Disable of Frame Dependent on the Option BUtton click.

Warm Regards
e4excel