I am encountering a problem in Excel VBA in adding items to the combo box.
I used this code:
Private Sub cbox_DropButtonClick()
cbox.AddItem "DO at Distance x (mg/L)", 0
cbox.AddItem "Critical Time (d)", 1
cbox.AddItem "DO at Critical Time (mg/L)", 2
cbox.AddItem "Distance at Critical Time (km)", 3
However, everytime i click the arrow of the combo box, the items double.
I tried putting cbox.Clear at the beginning and the end of the code but it led to other problems.