Clear ComboBox selection

[ipbr21054]

Hi,
I have a ComboBox with 3 selections within it
Selection ONE TWO & THREE

I select TWO but i need a reset button.

This is my reset button code at present.

Private Sub CommandButton1_Click()
UserForm_Initialize
End Sub

I wish to press the reset button and have the ComboBox empty like it was before i made the selection.

I have tried the following but it either gives me a compile error or its clears the combobox BUT just adds the same selections within the lis agin thus ONE THWO THREE ONE TWO THREE.

ComboBox2.SelectedIndex = -1

ComboBox2.ResetText

ComboBox2.Text = " "

ComboBox2Text = Null

Please can you advise how i make it show nothing selected BUT just keep the same list of ONE TWO THREE

 

[Norie]

If you want to clear items in a combobox use Clear.

ComboBox2.Clear

 

[ipbr21054]

Hi,
I think I did try

ComboBox2.Clear

But that also didn’t work.

Is the above written correctly ?

 

[Norie]

How are you populating the combobox?

 

[ipbr21054]

User form initialize add item method

 

[ipbr21054]

How are you populating the combobox?

This is the code

    Private Sub UserForm_Initialize()
        OptionButton1.Visible = False
        OptionButton2.Visible = False
        OptionButton3.Visible = False
        OptionButton4.Visible = False
        OptionButton5.Visible = False
        OptionButton6.Visible = False
        ComboBox2.AddItem "FERRARI TYPE"
        ComboBox2.AddItem "HYUNDAI FOB"
        ComboBox2.AddItem "ORIGINAL 2B"
        Label8.Visible = False
        Label9.Visible = False
        End Sub

When i use the following Yes it clears the incorrectly selected text but when i then click on the drop down the ONE TWO THREE isnt there.
I need to close then open the form again.

Private Sub CommandButton1_Click()
UserForm_Initialize
ComboBox2.Clear
End Sub

 

[EXCEL MAX]

I don't now what you mean about "ComboBox2.SelectedIndex = -1".
Did you mean you have try "ComboBox2.ListIndex = -1"?
I suggest to remove old combobox controls and replace with new with default properties.
"ComboBox2.ListIndex = -1" do the job.

 

[ipbr21054]

Thanks but that just added to the list so making everythiung there twice.
BUT this worked.

Private Sub CommandButton1_Click()
ComboBox2.Clear
UserForm_Initialize
End Sub

 

[Norie]

If all you want to do is clear what's entered/selected in the combobox use this.

ComboBox2.Value = ""

 

[ipbr21054]

Thanks.
I looked again using clear one you mentioned but swapped it around with the initialise code and it works.