Is it possible to have a ComboBox with a default value based on say Cell A1
which if there is a name, the name defaults in, otherwise it is blank. All
while still having the ability to use the dropdown list in the ComboBox?

Thanks for your ideas.