The combobox is located on a worksheet.

ComboBox1.Clear
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"

When I use the above code it prevents duplicate values
because of the clear but when I select a value from the
drop down it does not put the value in the combobox. The
combobox is just blank.

Todd,

It works fine for me. Are you using the DropButtonClick event to populate
it.

Show all the code.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Todd Huttenstine" wrote in message
...
The combobox is located on a worksheet.

ComboBox1.Clear
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"

When I use the above code it prevents duplicate values
because of the clear but when I select a value from the
drop down it does not put the value in the combobox. The
combobox is just blank.

yes I am using the code to populate it. Problem is once I
select a value, the value dissapears.


Private Sub ComboBox1_DropButtonClick()
ComboBox1.Clear
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"

-----Original Message-----
Todd,

It works fine for me. Are you using the DropButtonClick
event to populate
it.

Show all the code.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Todd Huttenstine"
wrote in message
...
The combobox is located on a worksheet.

ComboBox1.Clear
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"

When I use the above code it prevents duplicate values
because of the clear but when I select a value from the
drop down it does not put the value in the combobox.
The
combobox is just blank.


.