Make use of teh ListIndex property

From VBA Help:
"Values of ListIndex range from –1 to one less than the total number
of rows in a list (that is, ListCount – 1). When no rows are selected,
ListIndex returns –1"

so at whicever event you want the value to be cleared and force the
user to make a chose, set:

combobox1.listindex = -1

Brz



On Jul 23, 11:21*pm, PW wrote:
I have a combo box on a user form. *The first time I run it, it works fine. *
The second time I run it. *It has the previous selection in it. *How can I
have it come up blank?

Thank You,

PW