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.