Todd

Make the first line

Me.ComboBox1.Clear

If you're adding the same thing every time, why are using this event? Why
not do it in the UserForm_Initialize event?

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Todd Huttenstine" wrote in message
...
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