Hi Bruce

try this:

Me.ComboBox1.ListIndex = 0

Regards,
Per

"BrucenAZ" skrev i meddelelsen
...
I'm a bit confused about cell assignment of drop-down lists.

My drop-down list refers to an input range and cell link on a second
worksheet in the same workbook. For example, the Input Range is:
Sheet2!$A$2:$A$6 and the Cell link is: Sheet2!$A$8. I'm trying to create
a
macro that will reset the drop- down list to a default ""Choose answer"
item
in the list. For me, "Choose answer" is located in Sheet2!$A$2. The
drop-down list is located in Sheet1.

Does anyone know how to define the Range of a drop-down list in Excel?

Thanks,
Bruce