Hi, I'm new to this forum and new to VBA, I have a small question that I need a little help with.

I'm using excel 2003.

basically what I'm trying to do is create a combobox on sheet 1 of my workbook.

the code I've used is...


Private Sub ComboBox1_DropButtonClick()
With ComboBox1
ComboBox1.AddItem "aaa"
ComboBox1.AddItem "bbb"
ComboBox1.AddItem "ccc"
End With
End Sub

this does work, but each time I click on the combo box it repeats the list over and over again for each time I clikc on the list.

hope this is making sense.

thanks for any help in advance.

regards
Sukh