Clear combo box when changing option button

[brendalpzm]

Hello~

I have form controls option buttons that are linked to an activex combo box,

Depending on the option button the activex combo box changes its values. The issue is that when I select a value from the combo box and want to change the option button (this can happen when the user makes a mistake and wants to change) the combo box stays with the last input value and change its values until I click the dropdown button. Is there a way to blank the combo box so the last option doesn't show?

If you could help me I'd be clad

 

[sijpie]

Is this in a userform, or on a worksheet? I am assuming a worksheet, if you use an activeX control.

In the worksheet module add the following code for each of the option buttons, refering to the correct combobox to clear:

Private Sub OptionButton1_Click()
    ComboBox1.Value = ""
End Sub