Rest options available after listbox selection

[ipbr21054]

On my userform i select a value from ComboBox2
Its corresponding value is then shown in the way of an Option Button
Example of issue i see.
I select ListIndex1 value & then OptionButton 2 & 4 are visible which is correct.
BUT
If the user the decides he made the wrong ListBox selection & then selects ListIndex3 value OptionButton 5 & 6 are then shown BUT OptionButtion 2 & 4 are still also shown.
How can we somehow reset the OptioButton if the ListIndex selection are selected more than once

Thanks

I believe the code below is what you require

    Private Sub ComboBox2_Change()
        ComboBox2 = UCase(ComboBox2)
        If ComboBox2.ListIndex = 0 Then
        OptionButton5.Visible = True
        OptionButton6.Visible = True
        Label8.Visible = True
        Label9.Visible = True
        End If
        If ComboBox2.ListIndex = 1 Then
        OptionButton2.Visible = True
        OptionButton4.Visible = True
        Label8.Visible = True
        Label9.Visible = True
        End If
        If ComboBox2.ListIndex = 2 Then
        OptionButton5.Visible = True
        OptionButton6.Visible = True
        Label8.Visible = True
        Label9.Visible = True
        End If
        End Sub

 

[nemmi69]

Try

Private Sub ComboBox2_Change()
        ComboBox2 = UCase(ComboBox2)
        If ComboBox2.ListIndex = 0 Then
        OptionButton5.Visible = True
        OptionButton6.Visible = True
        OptionButton2.Visible = False
        OptionButton4.Visible = False
         Label8.Visible = True
        Label9.Visible = True
        End If
        If ComboBox2.ListIndex = 1 Then
        OptionButton2.Visible = True
        OptionButton4.Visible = True
        Label8.Visible = True
        Label9.Visible = True
        End If
        If ComboBox2.ListIndex = 2 Then
        OptionButton5.Visible = True
        OptionButton6.Visible = True
        OptionButton5.Visible = False
        OptionButton6.Visible = False
        Label8.Visible = True
        Label9.Visible = True
        End If
        End Sub

 

[ipbr21054]

Same haapens
Example

In ListBox i select FRUIT
I then see APPLE & PEAR optionbuttons

I made a mistake so i select from ListBox again but this time CARS
I still see APPLE & PEAR but ALSO FORD & BMW

I am looking for when i make the selection again from the ListBox that APPLE & PEAR are not shown BUT just FORD & BMW

Thanks

 

[nemmi69]

Sorry missed one option. Noticed that ListIndex 0 & 2 are the same

Private Sub ComboBox2_Change()
        ComboBox2 = UCase(ComboBox2)
        If ComboBox2.ListIndex = 0 Then
        OptionButton5.Visible = True
        OptionButton6.Visible = True
        OptionButton2.Visible = False
        OptionButton4.Visible = False
         Label8.Visible = True
        Label9.Visible = True
        End If
        If ComboBox2.ListIndex = 1 Then
        OptionButton5.Visible = False
        OptionButton6.Visible = False
        OptionButton2.Visible = True
        OptionButton4.Visible = True
        Label8.Visible = True
        Label9.Visible = True
        End If
        If ComboBox2.ListIndex = 2 Then
        OptionButton5.Visible = True
        OptionButton6.Visible = True
        OptionButton2.Visible = False
        OptionButton4.Visible = False
        Label8.Visible = True
        Label9.Visible = True
        End If
        End Sub