It didnt quite work. I inserted a combobox instead of a data validation list into the excel workbook. How do I hide the combobox if its built into the worksheet instead of a user form? Also, as a follow up the name for the combobox appears to be Drop Down 12. Do I need to rename the box so it doesn't contain any spaces or can i use underscores?

Thanks