Private Sub ComboBox1_DropButtonClick()
ComboBox1.AddItem "Jan Week 1"
ComboBox1.AddItem "Jan Week 2"
ComboBox1.AddItem "Jan Week 3"
ComboBox1.AddItem "Jan Week 4"
ComboBox1.AddItem "Jan Week 5"
ComboBox1.AddItem "Jan MTD"
End Sub

hey guys
The above code adds the specified values to ComboBox1 when
a user clicks the drop down box on the combobox. Problem
is when the user clicks the dropdown button again, the
values are added again so now there are 2 sets of the same
values. If the user clicks it again, a 3rd set is listed
and so on... How do I prevent these values from adding up?


Thank you
TOdd Huttenstine