Combo Box Question

[irresistible007]

I am just testing few things before starting over my lil project... I have putted a combo box on the sheet and want to display lets say France, Italy and Mexico and so did i used:

Private Sub ComboBox1_DropButtonClick()
ComboBox1.AddItem "France"
ComboBox1.AddItem "Italy"
ComboBox1.AddItem "Mexico"
End Sub

But above has a logical bug as when i click the dropdown for the first time it shows each item only once, but clicking again and again results each item to appear the no. of times the drop down was clicked... This is obvious error... please advise me the correct Method instead of using AddItem

 

[jindon]

Add one line before 1st additem

ComboBox1.Clear

 

[irresistible007]

Wow...thats so simple i didn't thought like that... thanks