Combobox.clear problem 1

[Jamesm601]

Hello all.

I have a userform with a three comboboxes. The first two define the criteria for what's to be displayed in the third. The code that evaluates the states of the first two comboboxes resides in the Dropbuttonclick() event of the third.

'Below code is in a Do loop that loops through all possible entries:
if region = Regioncombobox.value and Prioritycombobox.value = "High" then
  projectcombobox.additem region
end if

My problem is that in order to allow the user to drop down the third combobox without duplicate entries appearing, i've placed...

 Projectcombox.clear

in the Dropbuttonclick() event. This works, but prevents me from selecting from that list, because selecting calls the Dropbuttonclick() event which clears the list.

Does anyone know where I could place the Combobox.clear command so that it would clear the list before repopulating it, but not before selecting?

Thanks in advance for any help.

 

[mintjulep]

Exit event of the second box?

 

[Jamesm601]

Hi Mintjulep

Actually, I'm already doing that with one and two. But the user won't necessarily be leaving those boxes every time. I need to make it so they can click on the third combobox multiple times without the list doubling, then tripling, etc.

Thanks.

 

[mintjulep]

You are .add items on box3 enter event, right?

How about skipping the .add if there are already items?

if box2.list.count = 0

with box3

.add
.add

 

[Jamesm601]

Mintjulep,

You are the best. That works perfectly. Don't know why I didn't think of it myself.

Thanks a million.