If the value is in the combo list just set the Value property to that cell
value

ComboBox1.Value = Range("A1").Value

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"TimN" wrote in message
...
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.