View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
brzak brzak is offline
external usenet poster
 
Posts: 35
Default ComboBox displays last selection

I can only guess tht you're not resetting on all the possible events
where the user form appears.

A sample of the code would make it easier to see where the problem is.

Brz

On Jul 24, 10:23*pm, pw wrote:
The first time I run the macro, it works fine. *The second time I can't get
the combobox to be blank even with the code you used below. *Any idea why?

"brzak" wrote:
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