The code i provided is to go into the workbook not the worksheet, it fills the combobox when the workbook is opened.

I am not at a computer with Excel installed so i cant check your sheet yet.

You need to remove the link area from the properties window of the combobox as i touched on in my post above.

Hope this helps